Thanks for this, Buddy, appreciate your taking the time to produce the sample.
Yes, this is what I would expect but do not get on my end. Will take a look at your suggestions. Thanks, Brad Davidson Aero-Craft Hydraulics, Inc. From: [email protected] [mailto:[email protected]] On Behalf Of Buddy Walker Sent: Wednesday, December 21, 2016 5:48 AM To: [email protected] Subject: RE: [RBASE-L] - Separator Defined - Gateway Export Brad I used Excel and Notepad++ to open the attached file and everything appears to be ok. You may want to check and make sure you don’t have and rogue RBase DLL files. Also check your IDQUOTES to make sure they are the reverse single quote. Reload the database and as a last resort I would install the last R:Base update you have. Buddy From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Brad Davidson Sent: Tuesday, December 20, 2016 4:28 PM To: [email protected]<mailto:[email protected]> Subject: RE: [RBASE-L] - Separator Defined - Gateway Export Buddy, Yes, filename is TAB extension. Same results opening file in Excel as Tab Delimited file. I used notepad++ as a check against any anomalies with Excel (or with me!). Same results. Thanks, Brad Davidson Aero-Craft Hydraulics, Inc. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Buddy Walker Sent: Tuesday, December 20, 2016 1:24 PM To: [email protected]<mailto:[email protected]> Subject: RE: [RBASE-L] - Separator Defined - Gateway Export 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]> [mailto:[email protected]] On Behalf Of Brad Davidson Sent: Tuesday, December 20, 2016 4:16 PM To: [email protected]<mailto:[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. [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://cp.mcafee.com/d/k-Kr4zqb3OqrxEVKyCrKrhhK-OC-y_sSyztZVxZBVUSyztZBdZ5Z4SyztZVxNZxwSgzG78qpAxiI0lLNGnJ7npYKrTURbSzHI-ndILEWqenTD-LPz9EV78ILtuVtddVzAkhPb30UtORQr8EGTd7b7axVZicHs3jq9JMTvATDDDDDDDzhOrKr01rYqBXhRSvbCUAdFVsY0925y20UGXXJ32G4i3pyP393iF4mY-MyUoob0EzmF4_OcqJHkVsSOMC_sS2NF8Qg6BI5z8wc3hsaCBQQg5Ph0cuJItDm9Ew3LtB3Q3h0nd40iSvCdb6y0q3RGNCrvKrldkO> 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<http://cp.mcafee.com/d/FZsS72gwrhoujjsd7dQkPtPqadTSkTQnXCQkrLLcfILf6QkrLIFLELECQkrLLcefIc6O4tgV3jcAalw2J-diZEWXfBPu_6FuQttDOVJBZ7jhO-Y_R-spd78V5BXHTbFFLcsyyepoo73KmKzp55mVEVoVkffGhBrwqrjdK6XYCYYYYYYYYqejtPpesRG9px6dmRGshHkyv_bUxBlFRrCrygSDBPM0A8m883yHLKQcaEh8dCbccAdaAhrPX2bxxwI2ydqAj_8NGSJjBPrb2rZPob6Azh0qmMmcy0Md5MGqnjh0nd40NWSNStoCy0eZSkfgd41sQg1bp-oQIq81EfmH6pJ-VJDM6>. -- 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/FZsS86Qm7AQT3hPt5cTsSyztZBdZ5-VJ56XXP3XbPNJ56XXarWbW9J56XXP3zX31Ix7kegQP92Bo0HvzkLqeKPVsTLNGnJ7npYKrpvhQQsLLfZvD6jhOehpuWZOWqrP78EzCm61MXBHEShhlKqemel3PWApmU6CSjrxK_9Lfffffff6zATsSjDdqymohzlJqD4qR8D_O-8plqtmVCUAdFVsY0925y20UGXXJ32G4i3pyP393iF4mY-MyUoob0EzmF4_OcqJHkVsSOMC_sS2NF8Qg6BI5z8wc3hsaCBQQg5Ph0cuJItDm9Ew3LtB3Q3h0nd40iSvCdb6y0q3RGNCrvKrZCk4>. -- 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/5fHCN0q6h0SyMYCOCYztUTsSyztZBdZ5-VJ56XXP3XbPNJ56XXarWbW9J56XXP3zX31Ix7kegQP92Bo0HvzkLqeKPVsTLNGnJ7npYKrRdVXnTD-LOaabVEVssWZOWrbyv9Touu7nVqWdAklrIFYG7DR8OJMddECTzt-jhphho7fI8CXCOsVHkiP2cqJHkUzmF4_-nN3aHjGTcT4xJfbDw18gIgg75nvtEolgygaJyPVV3iF4mYMD1mwUm1h6Ji9_AoRrmFOVJxxZdUS2NF8Qg6BI5z8wc3hsaCBQQg5Ph0cuJItDm9Ew3LtB3Q3h0nd40iSvCdb6y0q3RGNCrvKrGAoRPI6v0BFY>. -- 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/2DRPow920srhoujpjuhKYrKrhhK-OC-y_sSyztZVxZBVUSyztZBdZ5Z4SyztZVxNZxwSgzG78qpAxiI0lLNGnJ7npYKrTURbSzHI-ndWCYZHXP_nV555YQsKetuVtdBNfAXIff3HYJt6OaaJSk-l3PWApmU6CQPrNK_9EIEEI3DS4jtPpesRG9px6dmRGshHkyv_bUxBlFRrCrygSDBPM0A8m883yHLKQcaEh85mNpYYxFkybuojwHgsb0EzmF4_OcqJHkVsSMM-CYr1oQAq83iS2NAg61EK5jiWq82VEw6fmSePH4Qg1TKOxW1EwbCy09rfP6Bzh0d1WRoPdLTdDBjdDzge>. -- 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.
