Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copy to CSV type without the Header
Message
From
04/01/2008 12:42:04
 
 
To
04/01/2008 12:37:20
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Novell 6.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01279455
Message ID:
01279457
Views:
21
>This is probably a simple one for you guys...
>
>I am trying to copy to contents of a table to a type CSV file without including the header line. I tried it with DELIMITED WITH "," and that eliminates the header, but doesn't include the quotes around character types. I need it to be just like the output by the COPY TO filename.txt type CSV where it puts quotes around character fields, and does not with numerics, but I need it to exclude the header.

Remove the header after that:
COPY TO xxxx.CSV CSV
lcFile = FILETOSTR([xxxx.CSV])
STRTOFILE(SUBSTR(lcFile, AT(CHR(13),lcFile)+2), [xxxx.CSV])
not tested
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform