Set heading off will prevent the column names When I need to do a tab delimited file I create a variable appending the fields and the tab control set var vtab = (char(009)) set var voutput = (.v1 + .vtab + .v2 + .vtab + .v3) etc You could also try changing the delimit character while doing the ascii output, but I find that confusing because you have to use the new delimit in your code also until to reset it, the normal comma's wont work until reset. set delimt = .vtab Mark Lindner Lindner & Associates PC 254 Second Ave Needham MA 02494 781 247 1100 Fax 781 247 1143
-----Original Message----- 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 rated recipes <http://food.aol.com/top-rated-recipes?NCID=aoltop00030000000004> and easy ways to stay in shape <http://body.aol.com/fitness/winter-exercise?NCID=aoltop00030000000003> 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> !
