Thank's Unfortunately the output needs to be formatted according to rules established by the government It looks like an ordinary CSV file but it is not, that's why I have chosen to make use of the report capabilities I have solved the problem using a search & replace in the output file. Luckily I don't need to produce this file many times
Tony -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Buddy Walker Sent: zaterdag 6 december 2014 1:23 To: RBASE-L Mailing List Subject: [RBASE-L] - RE: PRINT TXT using semicolon instead of comma You may want to check out GATEWAY EXPORT CSV. You can set the delimiter there. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Friday, December 05, 2014 10:18 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: PRINT TXT using semicolon instead of comma I do not believe the report will work for you. As I said, UNLOAD ... AS ASCII will get you there. Populate a temp table with the columns you want SET DELIMIT=';' OUTPUT .vFilename unload data from tablename as ascii OUTPUT SCREEN SET DELIMIT=',' you data will be semi delimited -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Tony IJntema Sent: Friday, December 05, 2014 8:53 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: PRINT TXT using semicolon instead of comma The DELIMIT is ; In the report there are 3 options, Comma delimited Tab delimited Fixed length The Comma delimited option does not reflect the DELIMIT setting. Tony -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: vrijdag 5 december 2014 15:20 To: RBASE-L Mailing List Subject: [RBASE-L] - RE: PRINT TXT using semicolon instead of comma SET DELIMIT=';' An unload as ascii will use the semi instead of the comma. While this setting is in place, you may need to change your SEMI setting and use semi instead of comma in your code. MAKE sure to change you settings back to normal when the report is done. Dennis McGrath -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Tony IJntema Sent: Friday, December 05, 2014 5:04 AM To: RBASE-L Mailing List Subject: [RBASE-L] - PRINT TXT using semicolon instead of comma Hi, I have to print a comma separated TXT report, but the comma has to be a semicolon. Is there a report setting available to change this from a comma to a semicolon? Tony --- 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. ================================================ --- 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. ================================================
