Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append delimited
Message
 
 
À
19/06/2004 14:49:03
Denis Filer
University of Oxford
Royaume Uni
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00915373
Message ID:
00915379
Vues:
9
This message has been marked as the solution to the initial question of the thread.
Hi Denis,

There're two extra "%' characters, one at the begining and another at the end of each line which you've to take into account. The following code works for me (VFP8SP1).
CREATE CURSOR test (f0 C(1), f01 C(1), f02 C(3), f03 C(5), f99 C(1))
APPEND FROM test.txt DELIMITED WITH "" WITH CHARACTER %

* test.txt
%a%bbb%cccccc%
%a%bbb%cccccc%
%a%bbb%cccccc%
>I have been trying to do a basic "Append from myfile delimited with %" command with a txt file that has e.g. "%a%bbb%cccccc%dd%. Not having much success. The VFP 8 import wizard does it fine. Is % an OK delimiter? Have appended fine previously with tabs and commas withourt problem. Thanks, Denis
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform