Is it possible to export a cursor/table to Pipe Delimited with Headers without rolling my own?
Thanks
Chris.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
AFAIK - I don't think so. I remembered needing to do the same thing a number of years ago - and I think I had to kind of add the headers by hand. If I'm not mistaken...
And - by hand - I mean doing low-level file handling - or some such.
-K-
On 2/7/2019 6:13 PM, Chris Davis wrote:
Is it possible to export a cursor/table to Pipe Delimited with Headers without rolling my own?
Thanks
Chris.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
Worked around it for now like so ...
*** to give me the headers without any lines COPY TO customerheaders.csv FOR 1=0 TYPE CSV *** to give me the lines pipe limited with no quotes or commas COPY TO customerlines.csv TYPE delimited WITH "" WITH CHARACTER "|" ***to merge the two files together and convert the commas in the headers to pipes STRTOFILE(STRTRAN(FILETOSTR("customerheaders.csv"),",","|")+FILETOSTR("customerlines.csv"),"customer.csv")
Seems to work ok.
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Kurt at VR-FX Sent: Friday, 08 February 2019 02:35 To: profoxtech@leafe.com Subject: Re: Pipe Delimited
AFAIK - I don't think so. I remembered needing to do the same thing a number of years ago - and I think I had to kind of add the headers by hand. If I'm not mistaken...
And - by hand - I mean doing low-level file handling - or some such.
-K-
On 2/7/2019 6:13 PM, Chris Davis wrote:
Is it possible to export a cursor/table to Pipe Delimited with Headers without rolling my own?
Thanks
Chris.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]