Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append from with pipe delimiter causes blank fields
Message
De
10/04/1998 14:18:37
 
 
À
10/04/1998 11:33:12
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00091069
Message ID:
00091153
Vues:
27
Thanks Myron - That did the trick. While the program for which I had to do this was actually written in Foxbase for DOS, as long as I can do it in VFP and get the desired result, that's fine. But if I understand the other replies correctly, it sounds like the pipe is the problem here.

>Try the following syntax
>
>append from delimited with character '|'
>
>-myron kirby-
>myronk@flash.net
>------------------------------------------
>>I had to import a text file which has pipes as the delimiter. When I use APPEND FROM DELIMITED WITH | I get a bunch of records with blank fields. I went into Modi file and replaced all the pipes with commas. Then I reissued the append command as "Append from type delimited", and the data came over into the table with no problem. Does anyone have any idea why this might have happened?
>>
>>Sylvia
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform