How about something like:
lcFileName = "c:\temp\test.csv"
copy to (lcFileName) csv
CR = chr(13) + chr(10)
=strtofile(strtran(filetostr(lcFileName), CR, CR + CR), lcFileName)
Cheers,
Andrew
>Can anyone show me how to use low level file function to complete this
>
>export record from a table as format cvs
>and insert blank line
>export following record
>
>eg.
>
>customername1,pono,deldate,item,qty,amt
>
>customername2,pono,deldate,item,qty,amt
>
>customername3,pono,deldate,item,qty,amt
>
>customername4,pono,deldate,item,qty,amt
>
>
>
>I cannot use COPY TO temp TYPE CVS command because I need to insert a blank line between record.
>
>TIA.
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.