Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lazloth
Starting Member
2 Posts |
 Posted - 2002-08-05 : 15:14:54
|
| Hi, I was wondering if someone knew an easy method to spool the output from a bcp export without a using delimiter?I'm dealing with an application that parses the fields by fixed length, and because there is data massaging necessary, I don't want to use a delimiter. I've been using a whitespace and trimming it off, but feel the additional work is silly. (So, for example, if I have a situation where I concat three fields, I'd have to truncate two of the fields before this operation could occur.)If I'm not mistaken, the default delimiter is a tab -- is there any mechanism anyone knows to remove this altogether?Thanks. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-05 : 15:44:38
|
| Sure, take a look in Books Online for "bcp format files". You can set up a format file with an empty string "" for column terminator (make sure the last column has a row terminator like \n or \r) If you manually run bcp from the command line, without specifying column or row terminators (or a format file) it will prompt you for the column settings, and then ask if you want to save the format file. This is probably the easiest way to set it up. |
 |
|
|
|
|
|
bcp export non-delimited?