Member Avatar for Tommymac501

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
  • 221 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Tommymac501
Member Avatar for Tommymac501

Solved it.. I didn't notice the Pipe was followed by a comma in my code..

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.