CSVWithoutQuotesIU
|
Group |
|
|
Class Name |
com.ebd.hub.datawizard.iu.CSVWithoutQuotesIU |
|
Function |
This unit creates a CSV file without quotes. |
Description
Introduction: Integration Units.
Usually, if you create a CSV file in a Response Route with content CSV, the content of some destination structure fields is put in quotation marks ("), for example, if a destination structure field of type String contains the CSV field delimiter character. For the delimiter semicolon (;) the field value aaa;bbb would result in value "aaa;bbb" in the output file.
The Integration Unit CSVWithoutQuotesIU creates a CSV file that does not contain quotation marks. So instead of "aaa;bbb" (as described above), the value in the output file would be aaa;bbb. Please note that this would lead to an additional field in the CSV file since the semicolon would now be interpreted as a field delimiter.
It should also be noted that the parameter only quote alphanumeric values=true generally puts the values of all destination structure fields of type String in quotation marks in the output file. All numerical fields do not receive quotation marks.
Parameter Description
|
Parameter Name |
Allowed Values |
Default Value |
Description |
|
add csv delimiter at end |
true, false |
false |
Adds a CSV delimiter at the end. |
|
csv delimiter |
; |
CSV field delimiter (see note). |
|
|
end of line |
\n |
CSV line delimiter. |
|
|
only quote alphanumeric values |
true, false |
false |
If true, only values of destination structure fields of type String are quoted. |
Example
|
Content of Destination Structure Field |
Type of Destination Structure Field |
CSV Delimiter |
Parameter only quote alphanumeric values |
Value In Output File |
No Integration Unit |
|
aaa;bbb |
String |
; |
false |
aaa;bbb |
"aaa;bbb" |
|
ccc |
String |
; |
false |
ccc |
ccc |
|
33 |
Integer |
; |
false |
33 |
33 |
|
aaa;bbb |
String |
; |
true |
"aaa;bbb" |
"aaa;bbb" |
|
ccc |
String |
; |
true |
"ccc" |
ccc |
|
33 |
Integer |
; |
true |
33 |
33 |
Note: Particularly for the work with the data format CSV, a delimiter must be defined, which is expected at various points. If a non-printable character is to be used as the separator, e.g. a control character, that character cannot simply be entered using the keyboard. In this case, a periphrasis is expected. The following periphrases are supported.
|
TAB |
Horizontal tab. |
|
NL |
Newline. |
|
CR |
Carriage return. |
|
0x<hexcode> |
Specified in hex code (2 characters [0-F]). |
Note: Also see section Representation of Nonprintable Delimiters.