I'm glad I posted the question. The feedback has taught me much. Thank you all.
On Fri, Apr 15, 2016 at 4:31 AM, Tracy Pearson <[email protected]> wrote: > 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 > > [excessive quoting removed by server] _______________________________________________ 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/CAG1nNy_jpGb6+X=KNqXc=wnH=lkkcahefykd3z5yya6uce5...@mail.gmail.com ** 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.
