Sytze de Boer wrote on 2016-04-13:
> My client has asked me to export specified data to a CSV file
> That's the easy part.
> I have a CSV file with a header and 500 detail lines.
>
> Now he has asked that
> Column 1, Row 1, (the header) MUST be called *contactname
> Column 7, Row 1, (some details) MUST be called *PAYDUEDATE
> ....and a few others
>
> As you can see, this is more than 10 characters.
> I need some help here.
> Whats the easiest way to automate this?
Sytze,
If you are lucky enough to be able to use the COPY TO ... TYPE CSV, it may
be easier than you think:
CREATE CURSOR csvoutput (contname c(30))
INSERT INTO csvoutput VALUES ("Paul")
INSERT INTO csvoutput VALUES ("John")
SELECT contname as ContactName FROM csvoutput INTO CURSOR finaloutput
COPY TO sytzetest TYPE CSV
MODIFY FILE sytzetest.csv NOWAIT
Tracy Pearson
PowerChurch Software
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.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.
