Wow - Alan - I think that approach is even Easier! Too bad I didn't read your response until after I sent mine.
OK - time to drink some more coffee and wake the Heck Up! :-) -K- -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Alan Bourke Sent: Tuesday, October 12, 2010 2:49 AM Get your data in a cursor then: set textmerge on noshow set textmerge to myfile.csv \INVOICE NUMBER,CLIENT NAME,OTHER STUFF scan \<<invnum>>,<<clientname>>,<<otherstuff>> endscan set textmerge off set textmerge to On Tue, 12 Oct 2010 12:12 +1300, "Sytze de Boer" <[email protected]> wrote: > One of my clients needs to send information to their bank in CSV format > > The system my client uses is made up of free standing tables > The bank requires 3 csv files and insist on headers in exact format > I'm having a problem where the request for headers includes the following > INVOICE NUMBER (note the space and length) > CLIENT NAME (note the space and length) > > i.e. my routine to COPY TO BANK.CSV TYPE CSV does not like this > I would appreciate help for a work around > > > -- > Regards > Sytze de Boer > Kiss Systems _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/289ea162f5642645b5cf64d624c66a14071a2...@us-ny-mail-002.waitex.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
