Try this:
SET HEADINGS OFF SET LINES 0 Then do your output . Emmitt Dove Manager, DairyPak Business Systems Blue Ridge Paper Products, Inc. [EMAIL PROTECTED] [EMAIL PROTECTED] (203) 643-8022 From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, December 31, 2007 12:59 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Alastair - TAB DELIMITED QUESTION Your solution works, except when you output to a file, you also get the column names many times. Not really a clean way to create a true tab delimited file...but thanks to your insight, I feel I am getting closer. Thank you (SELECT Col_A, (CHAR(009)), Col_B, (CHAR(009)) FROM ...) -----Original Message----- From: Alastair Burr <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Sun, 30 Dec 2007 10:37 am Subject: [RBASE-L] - Re: TAB DELIMITED QUESTION Gateway allows you to export in TAB format. I don't remember ever being able to do so with the UNLOAD command although you could probably concoct a SELECT command to pick the columns you want and put a (CHAR(009)) between each one if you need to do it that way. (SELECT Col_A, (CHAR(009)), Col_B, (CHAR(009)) FROM ...) Regards, Alastair ----- Original Message ----- From: [EMAIL PROTECTED] To: RBASE-L Mailing List <mailto:[email protected]> Sent: Sunday, December 30, 2007 6:05 PM Subject: [RBASE-L] - TAB DELIMITED QUESTION Does anyone know how to export a to TAB delimited file format? CSV now works like this output c:\somefile.csv unload data for customers as csv output screen How can we programmatically unload data in a tab delimited format? THANKS IN ADVANCE! _____ See AOL's top <http://food.aol.com/top-rated-recipes?NCID=aoltop00030000000004> rated recipes and easy <http://body.aol.com/fitness/winter-exercise?NCID=aoltop00030000000003> ways to stay in shape for winter. _____ No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.17.12/1202 - Release Date: 29/12/2007 13:27 _____ More new features than ever. Check out the new AOL Mail <http://o.aolcdn.com/cdn.webmail.aol.com/mailtour/aol/en-us/text.htm?ncid=ao lcmp00050000000003> !
