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
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
> text/plain (text body -- kept)
> text/html
> ---
>
[excessive quoting removed by server]
_______________________________________________
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/[email protected]
** 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.
