Description
The unit generates a CSV file with a header row from the field names of the first active target structure node. The node attribute Only for SQL must also be set to No.
The data rows contain the field values. If a path is used, the unit generates multiple rows.
The unit ignores calculation fields. It resolves subnodes. Their fields are treated as fields of the parent node.
Parameters
Parameter | Allowed values | Default value | Description |
|---|---|---|---|
always quote |
|
| Quotes all fields, including numeric fields and fields without special characters or whitespaces. |
as csv of excel |
|
| Generates CSV in the same format as MS Excel. |
csv delimiter |
| The CSV field delimiter (see note). | |
csv quote |
| The CSV quote character for fields. | |
end of line |
| The CSV line ending character. | |
use normalized header names |
| If | |
suppress header creation |
|
| If |
NOTE
CSV expects field delimiters in multiple places. Some delimiters are non-printable, such as control characters. You cannot enter these directly using the keyboard. In this case, you must use an escape sequence. The unit supports the escape sequences listed in the table below.
TAB | Tab character. |
NL | New line. |
CR | Carriage return. |
0x<hexcode> | Hex code notation (2 characters [0- |