Brad Not sure how you are unloading the data but this works for RBASE X
Buddy GATEWAY EXPORT TAB C:\TEMP\Employee.TAB + SELECT * FROM EMPLOYEE + OPTION COL_NAMES ON + |SEPERATOR TAB + |QUALIFIER " + |REC_SEP CRLF + |SHOW_PROGRESS ON + |ACTION OPENVIEW RETURN From: [email protected] [mailto:[email protected]] On Behalf Of Brad Davidson Sent: Tuesday, December 20, 2016 1:26 PM To: [email protected] Subject: [RBASE-L] - Separator Defined - Gateway Export Would appreciate your comments on this. I want to define the SEPARATOR value (separating fields in target text (tab delimited) file) as TAB. However, when attempting (per R:DOCS) to represent the value as TAB or (#9) per: |SEPARATOR TAB or |SEPARATOR (#9) OR |SEPARATOR (CHAR(009)) The result is not what is expected when viewing the file as a TEXT file, and/or, opening the file in EXCEL as a tab delimited file… If ‘TAB’ is specified, the file embeds only the letter ‘T’, again not what I expect, but then again, not sure what I should expect. Any clues on this? What should I see? What is the proper specified character for option: |SEPARATOR (?) Thank you! Brad Davidson Aero-Craft Hydraulics, Inc. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected] <mailto:[email protected]> . For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
