You're welcome Glad it helped you Tony
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Clive Williams Sent: zaterdag 9 juli 2011 11:04 To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Adding blank lines to export Thanks for that Tony. Regards Clive Williams CRW-logo_small CRW Services PO Box 483 Richmond NSW 2753 Mobile: 0418 657 833 A H: (02) 4578 5343 Skype: crwservices email: [email protected] www.crwservices.com.au MYOB Certified Consultant Ostendo Consulting Partner Xero Certified Advisor Registered BAS Agent MYOB Accredited Trainer Cert IV Workplace Training & Assessment Cert IV Financial Services (Bookkeeping) From: [email protected] [mailto:[email protected]] On Behalf Of A.G. IJntema Sent: Saturday, 2 July 2011 02:08 To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Adding blank lines to export Clive, Have a look at the report writer and make use of the output option TXT Please make sure you fill in the option File | Print to text file setup I think you easily can add an empty row using this feature. Tony From: [email protected] [mailto:[email protected]] On Behalf Of Clive Williams Sent: vrijdag 1 juli 2011 16:50 To: RBASE-L Mailing List Subject: [RBASE-L] - Adding blank lines to export G'day all I have a view constructed from a header and detail table to produce a tab delimited file. The problem is that the application that will import this file requires a blank line between each group of records, which can comprise one or many lines. In the old DOS days I would have used a cursor to process the rows and write a LFCR after each group of records. Using 9.1 64bit is there a better way to do this? Regards Clive Williams --- 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. ================================================

