Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Delimited Fields
Message
 
 
À
10/10/2000 17:46:45
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00427603
Message ID:
00427612
Vues:
12
Hi!

Use following command
copy to ... delimited with ' ' with character ','

Looks like this is most appropriate, however, you will see spaces around character field, like in sample data below:
441,8, CCITY , CCITY , CCITY , C ,25,0, ,F
I tried space(0) instead of ' ', but VFP generates error. When place '' - VFP will add single quote.


>I have 3 fields in a table that are char fields and i'm using a view to access my information and using this to write to a txt field and put put this record into the text as delimited fields.My problem is when i write these field to the text file as delimited i cant have these fields in "field"Im unable to change the table because it is used by other programs.Any suggestions on how to get rid of these "" before i write to my text file.
>Any help is appreciated.
>Thanks Linda
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.com
ICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs

It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform