For what it is worth, I have found the following version to work impeccably. Excel defaults to using double quotes When used this way, double quotes with AS ASCII has never failed to be evaluated 100% correctly by Excel.
SET EOF OFF SET NULL ' ' output SomeFileName.csv SET QUOTES="""" --four double quotes Unload data from SomeTable using ColList as ASCII SET QUOTES='''' -- four single quotes Output Screen SET NULL '-0-' SET EOF ON Dennis McGrath -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mike Byerley Sent: Thursday, June 17, 2010 9:12 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Gateway Export in EEP In a Pinch, use: output SomeFileName.csv {if all columns} Unload data from SomeTable using ColList as CSV {or if specific columns} Unload data from SomeTable using * as CSV Output Scr ----- Original Message ----- From: "Wills, Steve" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, June 17, 2010 10:00 AM Subject: [RBASE-L] - RE: Gateway Export in EEP Frank, given the inability to use Gateway in an EEP, if the functionality must be delivered in an EEP, could you format it via a report, then print that report, outputting to XLS? I am only suggesting the possibility, as I have never done this, but it might offer you another avenue to a solution. P=1.0: Value <= $0.02, Steve in Memphis From: [email protected] [mailto:[email protected]] On Behalf Of A.G. IJntema Sent: Thursday, June 17, 2010 6:46am 06:46 To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Gateway Export in EEP Hi Frank, Your name looks Dutch maybe even Friesian. You can create an RGW at export by taking the first row at Select Format (gateway, export). The first option is Use Export wizard The you are able to create an export wizard and it can be saved as RGW. It took me also a while before I noticed this option The procedure can look like this GATEWAY EXPORT XLS <filename> + SELECT + <field1>, + <field2>, + ... <fieldn> + FROM <viewname> + WHERE <whereclause> + OPTION |SHOW_PROGRESS ON + |ACTION OPENVIEW + |SPECIFICATION_FILE_NAME <filename_rgw>.rgw However you cannot use this procedure in an EEP, because an EEP does not allow to make use of GATEWAY. Hope this helps Tony IJntema The Netherlands From: [email protected] [mailto:[email protected]] On Behalf Of frank van der Zwaag Sent: donderdag 17 juni 2010 13:22 To: RBASE-L Mailing List Subject: [RBASE-L] - Gateway Export in EEP Hi All, does anybody have a sample EEP script that I can use to export the data from a view into an xls spreadsheet using a pre-defined export format (rgw) file. Thanks --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
