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.