?
Solved

How to export BCP with Pipe Delimiter

Posted on 2015-01-12
4
Medium Priority
?
1,856 Views
Last Modified: 2015-01-14
Hi..
What is the syntax to export with a pipe '|' as delimiter


this if for CSV or comma


set @s = 'bcp "'+ @SQL + '" queryout ' + @FilePath + ' -c -t, -T'
exec master..xp_cmdshell @s
0
Comment
Question by:JElster
  • 2
4 Comments
 
LVL 53

Expert Comment

by:Vitor Montalvão
ID: 40546873
Delimiter for what? Field or row?
Field delimiter: set @s = 'bcp "'+ @SQL + '" queryout ' + @FilePath + ' -c -t ¦ -T'
Row terminator: set @s = 'bcp "'+ @SQL + '" queryout ' + @FilePath + ' -c -t, -T -r ¦'
0
 
LVL 1

Author Comment

by:JElster
ID: 40546878
field
0
 
LVL 53

Expert Comment

by:Vitor Montalvão
ID: 40546886
Then is the first solution. You defined as comma so you just need to change it to pipe.
0
 
LVL 35

Accepted Solution

by:
Robert Schutt earned 2000 total points
ID: 40548894
Note that the pipe character is a special character to the command interpreter. You need to escape it using the Circumflex character:
set @s = 'bcp "'+ @SQL + '" queryout ' + @FilePath + ' -c -t^| -T'

Open in new window

0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question