Documentation / Commands / SET SEPARATOR

SET SEPARATOR

Core command SEPARATOR SEP SET SEP

Specifies a columns separator for export to text files (default is pipe)

Arguments

<caracter> (optional). If no argument, displays current columns separator

Examples

SET SEP |;

Notes

Sets the column separator used when exporting query results to text files: SET SEPARATOR <value>.

value is optional; without it, the command only displays the current separator. When given, a single character is used literally; otherwise it is looked up (case-insensitively) among the named values COMMA, DEFAULT (tab), ENTER/NEWLINE, PIPE, SEMICOLON, SPACE, TAB. An unrecognized multi-character value silently falls back to a pipe (|) rather than raising an error.

The current separator is always echoed back after the change, together with its name when it matches one of the named values above.

Does not affect PULL ... AS CSV/TXT (see com.projectsontracks.controller.shell.commands.core.export.CommandPull, docs/PULL_TO_TEXT.md): that command uses its own, separate CsvSeparator INI setting for AS CSV (semicolon if absent) and always a literal tab for AS TXT, deliberately independent of this session-level setting - only EXPORT/DUMP's .txt output (not .csv, which is always comma regardless of this setting) actually honors what SET SEP holds.

Last modified in release 5.0.3.