Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append delimited
Message
 
 
To
19/06/2004 14:49:03
Denis Filer
University of Oxford
United Kingdom
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00915373
Message ID:
00915379
Views:
10
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform