Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append from
Message
From
15/07/2006 05:54:09
 
 
To
14/07/2006 20:00:04
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
01136604
Message ID:
01136639
Views:
9
>How would you append from a text file reading each line of the text file into 1 record of the dbf if the text line includes commas that you don't want to loose? Every attempt I've made brings in just the text to the first comma.
>
>Thx
CREATE CURSOR test (field1 C(250),field2 C(250))
SET TEXTMERGE TO "SOMETEXT.TXT" OFF NOSHOW
\\LINE 1 COLUMN 1, LINE 1 COLUMN 2
\LINE 2 COLUMN 1, LINE 2 COLUMN 2


SET TEXTMERGE TO

delimiter = CHR(13)
APPEND FROM SOMETEXT.TXT TYPE DELIMITED WITH CHARACTER "&delimiter"
BROWSE
Previous
Reply
Map
View

Click here to load this message in the networking platform