CSVWithHeaderUnit
|
Class name |
com.ebd.hub.datawizard.iu.CSVWithHeaderUnit |
The Integration Unit creates a CSV file with a header line consisting of the field names of the first active target structure node. In addition, the node attribute "Only for SQL" must be set to "No".
The next line (or lines if you are working with a path) then consists of the field values.
Calculation fields are ignored. Subnodes are dissolved, i.e. their fields are used as if they were fields of the parent node.
See example profile below.
Parameters
|
Parameter name |
Allowed values |
Default value |
Description |
|
always quote |
true, false |
false |
Quoting all fields, even numeric values and values without special characters, or whitespaces. |
|
as csv of excel |
true, false |
false |
Create CSV file in Microsoft Excel conform format. |
|
csv delimiter |
|
; |
CSV field delimiter (see note). |
|
csv quote |
|
" |
Quote character. |
|
end of line |
|
\n |
CSV line delimiter. |
|
use normalized header names |
true, false |
|
If true, then a header field name field#3 becomes field. |
|
suppress header creation |
true, false |
false |
If true, no header is created. |
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 can not simply be entered using the keyboard. In this case, a periphrasis is expected. The following periphrases are supported.
|
TAB |
Horizontal tab. |
|
NL |
New line. |
|
CR |
Carriage return. |
|
0x<hexcode> |
Specified in hex code (2 characters [0-F]). |
Note: Also see section Representation of nonprintable delimiters.