I have version 6.5 - Cant really use Gateway - for some reason I get an error "There is insufficeint disk space in either the target drive or the temporary file drive" - Eventhough I have plenty of space.. .
-----Original Message----- From: Sami Aaron <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Mon, 31 Dec 2007 10:16 am Subject: [RBASE-L] - Re: Alastair - TAB DELIMITED QUESTION As Alastair also suggested – use the GATEWAY command: You don’t mention the version of R:BASE you are using, but in 6.5++ the syntax was: GATEWAY EXPORT TAB filename SELECT clause Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, December 31, 2007 11:59 AM 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 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 and easy 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! ________________________________________________________________________ More new features than ever. Check out the new AOL Mail ! - http://webmail.aol.com
