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. [http://www.aero-craft.com/image/108353241_scaled_1500x274.png] [Awards Logo] 951.736.4690 [email protected]<mailto:[email protected]> www.aero-craft.com<http://www.aero-craft.com> From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Tuesday, December 20, 2016 11:13 AM To: [email protected] Subject: RE: [RBASE-L] - Separator Defined - Gateway Export Maybe separator is misspelled? Dan Goldberg From: [email protected] [mailto:[email protected]] On Behalf Of Buddy Walker Sent: Tuesday, December 20, 2016 11:03 AM To: [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]. For more options, visit https://groups.google.com/d/optout.
