Quote processing for load operations, Quote processing for extract operations, Quote processing – HP Neoview Release 2.3 Software User Manual
Page 65
For Windows platforms: CR/LF (carriage return/line-feed)
—
— For Unix-like systems: LF (line feed)
— For the Macintosh family: CR (carriage return)
Quote Processing For Load Operations
For a load operation involving a delimited dataformat:
•
There is no default quoting character. Quote processing is disabled if this option is not
specified.
•
When optionally qualified by is specified and the first non-blank character in an
input field is the quoting character, Transporter treats all characters between that leading
quote character and the corresponding closing quote as input data. Inside the leading and
closing quotes, any double-occurrences of the quoting character are considered part of the
input data and are interpreted as single occurrences.
•
Field delimiters are allowed within quotes and are treated as part of the input data.
•
If no closing quote is found, the input record is rejected and written to the
file.
•
If a closing quote is found but it is not the last non-blank character of the input field, the
input record is rejected and written to
•
If quoting characters are present in an input field but the first non-blank character is not the
quoting character, no quote processing is performed.
For example, assume the quoting character is a double-quote ("") and the field delimiter is
a comma:
Interpreted as ...
Input Data
New York, NY
“New York, NY”
Not “quoted”
Not “quoted”
Yes “Quoted”
“Yes ""quoted"""
Quote Processing For Extract Operations
For an extract operation involving a delimited dataformat:
•
There is no default quoting character. Use optionally qualified by to specify a quoting
character, otherwise quote processing is disabled.
•
When you specify optionally qualified by:
— Date/Time and Character values are quoted.
— For other data types, any value containing the field delimiter is quoted.
— Within a quoted value, any occurrence of the quoting character is doubled. For example
if the quoting character is a single quote (') and the character value ab'cd'ef is moved
to an extract target, the characters written to the target are: 'ab''cd''ef'.
•
Other considerations for quoted data:
— Field delimiters are allowed and not treated as special characters within a quoted value.
This allows cases where, for example, an address field contains commas and comma
(,) is the field delimiter. Record separators cannot be embedded into a quoted value.
— You can use fixed-width data formats to avoid the overhead of quote processing.
Examples:
— To qualify by double-quotes (""):
optionally qualified by "
— To qualify by single-quotes (""):
Delimited Data
65