Column Separators

Previous Next

See Also

Column separators in external sets for export tasks normally depend on the file format chosen when defining the task. However, it is possible to override this at run time, using the colsep parameter.

The syntax of the colsep parameter is:

ActionStartJob(<job>,[<external set>:]colsep=<separator>)

Example

ActionStartJob(EXP_1,colsep=\n)

You can define a string of more than one character as a column separator, and use the following escape sequences for special characters.

\t    Tab

\n    Newline

\s    Single quote (')

\d    Double quote (")

\\    Backslash (\)

So, for example, if you have an export task that exports data to a file in CSV or VARIABLE format, it is possible to change this to a tabbed format by using the colsep parameter with value: "\t".