Export file as Tab Delimited WITH or WITHOUT Quotes

Build your list of AccuZIP6 commands by requesting commands and sharing commands with other users

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
Kristen
Moderator
Posts: 726
Joined: Wed Sep 20, 2006 3:46 pm

Export file as Tab Delimited WITH or WITHOUT Quotes

Post by Kristen » Fri May 09, 2008 2:26 pm

To export as tab delimited text with quotes, use:

Code: Select all

COPY TO "C:\TEST_WITH_QUOTES.TXT" TYPE DELIMITED WITH TAB
To export as a tab delimited WITHOUT quotes, use:

Code: Select all

COPY TO "C:\TEST_WITHOUT_QUOTES.TXT" TYPE DELIMITED WITH "" WITH TAB

Post Reply