CODEWITHSUNDEEP
sqlsql-serverpowershell
AleX_
AleX_

Reputation: 508

How to use multiple characters as a separator in SQLCMD

I'm running a SQL query in PowerShell using the SQLCMD, one of the posts shows how to use TAB as a separator. I'd like to have a fancier sequence of characters such as TAB-Comma-Space or Tab-Comma-Tab. I've tried 

-s `"`t,`t`"
-s `"`t`, `"

but it still uses a single Tab as the separator.

Thanks in advance.

Upvotes: 0

Views: 1316

Answers (1)

UnhandledExcepSean
UnhandledExcepSean

Reputation: 12804

Not possible according to the documentation.

-s col_separator
Specifies the column-separator character. The default is a blank space. This option sets the sqlcmd scripting variable SQLCMDCOLSEP. To use characters that have special meaning to the operating system such as the ampersand (&), or semicolon (;), enclose the character in quotation marks ("). The column separator can be any 8-bit character.

You might want to think about using a character like the hat/caret (^) as your delimiter and mass replacing that in the output. Not sure what single character would be least likely to conflict with your dataset.

Upvotes: 3

Related Questions