0

I have a SQL file that needs to be BCP exported to pipe delimited because of limitations on the recieving end.

I have tried the following with no sucess;

[BCP sql statement] + '.txt" -t"|", -c -T'
[BCP sql statement] + '.txt" -t\|, -c -T'
[BCP sql statement] + '.txt" -t^|, -c -T'

All of them produce the pipe as the delimiter, but, the pipes are also followed by comma's. Does anyone know a way to supress the comma?

1
Contributor
1
Reply
2
Views
6 Years
Discussion Span
Last Post by Tommymac501
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.