|
| ColumnNamesInFirstRow | | Set to "true" if the first row of data contains the names of the data columns.
Valid descriptions in the first row will override default column names. |
| CsvDelimiter | | The symbol used to separate items in a line of a CSV file.
Supports any character or the following special escape sequences:
\t = Tab
\v = Vertical tab
\r = Carriage return
\n = Line feed
The default is a comma. |
| DestinationFilename | | (Required) The full path and name of the destination file. |
| EtlElementID | | Enter the ID of the Extract or Transform element that contains the data to be processed.
If this attribute does not have a value, then the system will use the data from the last Extract or Transform element. |
| ID | | (Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition. |
| RowDelimiter | | The character or string used to terminate each row of data in a text file. For best results, the character used should not be found within the data.
If left blank the default delimiter is a line feed (Lf).
Lf = End each line of data with just a line feed (Default).
Cr = End each line of data with just a carriage return.
CrLf = End each line with a carrage return and line feed.
|
| TextQualifier | | If given, then values having this symbol at the beginning and end are treated as text:
1) the text qualifier symbol is removed from the beginning and end
2) if the text qualifier symbol is doubled within the value, it is replaced with a single text qualifier symbol
example using single quote as text qualifier:
144, 12/18/2004, 'Lee''s House of Kebab', '719 High Street'
144 12/18/2004 Lee's House of Kebab 719 High Street
The default is a quote mark ("). |
| TextQualifierMode | | Auto: (Default) If the value contains the delimiter, then the text will be enclosed within the TextQualifier.
On: All values will be surrounded by qualifiers.
Off: No values will be surrounded by qualifiers. |