Brad Are you saving the file as filename.TAB or filename.TXT and if it is .TAB you should make sure the file association for .TAB is Excel and not notepad.
Buddy From: [email protected] [mailto:[email protected]] On Behalf Of Brad Davidson Sent: Tuesday, December 20, 2016 4:16 PM To: [email protected] Subject: RE: [RBASE-L] - Separator Defined - Gateway Export Thanks Buddy, Dan: Dan the spelling is right, not the issue – wish it were! Buddy, your syntax same as mine. When the exported file opens to notepad++ (via OPENVIEW) the letter T appears as the delimiter. This is RBASEXE. Brad Davidson CIO, Director Aero-Craft Hydraulics, Inc. 951.736.4690 [email protected] <mailto:[email protected]> www.aero-craft.com <http://www.aero-craft.com> From: [email protected] <mailto:[email protected]> [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Tuesday, December 20, 2016 11:13 AM To: [email protected] <mailto:[email protected]> Subject: RE: [RBASE-L] - Separator Defined - Gateway Export Maybe separator is misspelled? Dan Goldberg From: [email protected] <mailto:[email protected]> [mailto:[email protected]] On Behalf Of Buddy Walker Sent: Tuesday, December 20, 2016 11:03 AM To: [email protected] <mailto:[email protected]> Subject: RE: [RBASE-L] - Separator Defined - Gateway Export 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]> [mailto:[email protected]] On Behalf Of Brad Davidson Sent: Tuesday, December 20, 2016 1:26 PM To: [email protected] <mailto:[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 <http://cp.mcafee.com/d/FZsScCQm7AQT4kn7ztPqadTSkTQnXCQkrLLcfILf6QkrLIFLELECQkrLLcefIc6O4tgV3jcAalw2J-diZEWXfBPu_6FuQttDOVKV1dUQsLLfZvArITKOMeWZOWqqbD8CzBBCXbOvkhjmKCHtNXBgY-F6lK1FJ4SOrLOoVcsCej79zztPpesRG9px6dmRGshHkyv_bUxBlFRrCrygSDBPM0A8m882Q1MISWSHm90ZxRxAxFkybuCIaq-7yMa8RGhfYz6HqRendEzC4nzob6Azh0qmMmcy0Md5MGqnjh0nd40NWSNStoCy0eZSkfgd41sQg1bp-oQIq81EfmH6pJ-VKCQD> . -- 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 <http://cp.mcafee.com/d/FZsScz8Ad21J5xVddN55NUTsSyztZBdZ5-VJ56XXP3XbPNJ56XXarWbW9J56XXP3zX31Ix7kegQP92Bo0HvzkLqeKPVsTLNGnJ7npYKrKgjud7bXP_nV6XdXII3KLsKCCyVO9EVppKOYDR4kRHFGTsuVkffGhBrwqrjdICXYCej79zANOoUTsSjDdqymohzlJqD4qR8D_O-8plqtmVCUAdFVsY0925y20J0sbdKJGRygfotop8ql8yTFH2CLxUI2ydqAj_8NGSJjBPq8Vx5US2NF8Qg6BI5z8wc3hsaCBQQg5Ph0cuJItDm9Ew3LtB3Q3h0nd40iSvCdb6y0q3RGNCrvKr5xpjACaZP0N5> . -- 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 <http://cp.mcafee.com/d/2DRPow938srhoujjshhsudTdEETvpjvhvKrhhK-YM-OYYrhhK-OC-y-yrhhK-YMU-MMr8hR3AdcOgFm0aTURbSzHI-ndXYqBXhRSvbCXA4TzhO-Y_R-hKPuXb0XHTbFFEKsyqemmrIL9Zh5dqWqJT7Kl3PWApmU6CSjr9K_9zANOoVcsCedTdAVPmEBC4oRrmFN6Ji9_YLy6lmDlKpK93qunf02gxowwbg72PrHqJoA3S7m6i6Bi8JWqMFHUub0EzmF4_OcqJHkVsSyeohudwIqid41Fr1oO830Qn2FFtd41sQg37Hr7pRyq80XTpgZ0Qg5Ph04JDVziNEw6wZqIpCTXCSyPsnwFo> . -- 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.
