CSVWithoutQuotesIU
Class name |
com.ebd.hub.datawizard.iu.CSVWithoutQuotesIU |
Usually, if you create a CSV file in a Response with content "CSV", the content of some target structure fields is put in quotation marks ("), for example, if a target 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 target structure fields of type String in quotation marks in the output file. All numerical fields do not receive quotation marks.
Parameters
Parameter |
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 target structure fields of type String are quoted. |
suppress header creation |
true, false |
true |
If true, no header is created. |
use normalized header names |
true, false |
true |
If true, then a header field name field#3 becomes field. |
Example
Content of target structure field |
Type of target 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.