Hi all,
I'm using BCP to write a querys result to a text file. This works well except there's a business requirement that I use no delimiter between each field... So the output is based purely on column size.
Current output example:
When it needs to output similar to this:
The software that reads the file expects it similar to the required output... Only column size defining the space between fields.
Any ideas?
I'm using BCP to write a querys result to a text file. This works well except there's a business requirement that I use no delimiter between each field... So the output is based purely on column size.
Current output example:
0000043215 CompanyName CompanyAddress
When it needs to output similar to this:
0000043215CompanyName CompanyAddress
The software that reads the file expects it similar to the required output... Only column size defining the space between fields.
Any ideas?