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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 tab-delimited header file

Author  Topic 

pattyp
Starting Member

2 Posts

Posted - 2008-02-19 : 13:50:48
used bcp utility to send data to output file in tab-delimited format (-t\t), but headerfile is separate entity in this query.

when I set FILEheader = firstname,lastname...what must I use to change the comma to tab in the header string. I have tried various ways \t, {t}, [-t], and others. what am I missing?

pattyp
Starting Member

2 Posts

Posted - 2008-02-19 : 14:25:57
OK, I found the answer to my own question. The header row can handle the literal character of tab instead of the other formats. I was making it harder that it really was.
Go to Top of Page
   

- Advertisement -