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