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?