Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copy to CSV type without the Header
Message
De
04/01/2008 12:42:04
 
 
À
04/01/2008 12:37:20
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Novell 6.x
Database:
Visual FoxPro
Divers
Thread ID:
01279455
Message ID:
01279457
Vues:
20
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform