Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is the syntax of append from text file
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01310202
Message ID:
01310205
Views:
16
This message has been marked as the solution to the initial question of the thread.
CREATE CURSOR crsImport (fld1 C(20), fld2 N(10))
append from mytext.txt delimited
>
>I have a text file of the following format
>
>
>ABC3333, 23
>FDJFDDF, 0
>HFHFF, 5
>
>
>Basically the text file has two values in each row, one character and one numeric. I want to create a cursor with two fields, one character and one numeric (e.g. mycursor (fld1 c(20), fld2 n(10,0)))
>
>Then I want to append the content of the text file into the cursor.
>When I do it using the syntax
>
>
>append from mytext.txt sdf
>
>
>the entire row goes into the first field (fld1). Is it possible to call APPEND FROM and make it put each segment of the row in the appropriate field?
>
>Thank you in advance for any help.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform