Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TAB character delimited
Message
De
20/11/2000 10:17:12
Cindy Winegarden
Duke University Medical Center
Durham, Caroline du Nord, États-Unis
 
 
À
20/11/2000 07:21:57
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00443577
Message ID:
00443625
Vues:
14
Ron,

You can't do it with COPY TO alone, but you can strip out the quotes afterwards by doing:
COPY ALL TO xx DELIMITED WITH TAB
STRTOFILE(CHRTRAN(FILETOSTR([xx.txt]), ["], []), [xx.txt])
>Hello every one,
>
>Could somebody please help me with the folowing:
>
>I have a FoxPro table and i have to create a TAB delimited file from it.
>When I try this statement: COPY ALL TO xx DELIMITED WITH '' WITH CHARACTER TAB
>It creates file xx but the fields are not fully correct. It looks like this:
>
>"Name" "Address" etc...
>
>I don't want to have the double quotes around the words. Could somebody give me the correct statement?
>
>I like to see the output like this:
>
>Name followed by CHR(9) a none visual character Address , etc...
>
>Thanks in advance
>Ron :)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform