jkj2001
Posts: 142 Joined: Fri Mar 29, 2002 1:39 pm
Post
by jkj2001 » Thu Apr 11, 2002 12:33 pm
What's the appropriate tsql syntax for exporting data from one of my tables in quoted, delimited format? Something so that the resulting text file looks like:
"field1 value"^"field2 value"^"field3 value"
"field1 value"^"field2 value"^"field3 value"
etc. Thanks.
mark
Site Admin
Posts: 5519 Joined: Tue Apr 25, 2000 6:56 pm
Post
by mark » Thu Apr 11, 2002 12:51 pm
Use the -f ^ option. You may also want the -q option.
See
http://www.thunderstone.com/site/texisman/node299.html
For fancier formats you can write a small vortex script to export about any format you could come up with.
Texis User
Posts: 74 Joined: Thu Jul 13, 2006 8:47 am
Post
by Texis User » Mon Feb 05, 2007 8:01 am
mark
Site Admin
Posts: 5519 Joined: Tue Apr 25, 2000 6:56 pm
Post
by mark » Mon Feb 05, 2007 12:21 pm