|
Ispirer SQLWays Database Migration Software
/CDEL - Column delimiter
Syntax: /CDEL=ColumnDelimiter
This option specifies a column delimiter used in the text files. This option can be used for the CSV format only. The default value is a comma. It is possible to specify one or multiple characters as a column delimiter.
To specify the hexadecimal value of the delimiter, use the following syntax: 0xhh. For example, /CDEL=0x2c specifies a comma as the column delimiter. Non-printing characters like tab, carriage return and new line can be represented by \t, \r and \n accordingly. To specify a backslash character use \\.
You can combine different character representations to specify a column delimiter. For example, /CDEL=|||0x2c0x2c|||
Note. To use a TAB character as a column delimiter use the TAB output format.
You can specify this option in the initialization file. See Initialization File Options for details.