Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append from
Message
From
11/06/2001 08:06:15
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00517666
Message ID:
00517676
Views:
14
Werner,
Something like the following should work:
lnLines = ALINES(laLines, FILETOSTR( File > ))

FOR i = 1 TO lnLines
    *-- get record
    lcRecord = laLines[i]
    *-- remove double quotes and replace the comma with a carriage return
    *-- and place record into an array
    lnFields = ALINES(laRecord, CHRTRAN(CHRTRAN(lcLine, ["], ""), ",", CHR(13)))
    *-- add record
    INSERT INTO  FROM ARRAY laRecord
ENDFOR &&* i = 1 TO lnLines
If your file is large, you could use FOPEN() and FGETS() instead of ALINES(FILETOSTR())
HTH

>I want to convert a txt-file (comma-delimited) into a table with memofields.
>when I enter the command:
>APPEND FROM 'advisor.txt' TYPE DELIMITED WITH ,
>he answers me:
>No fields found to process.
>
>What do I wrong?
>
>regards
Daniel
Previous
Reply
Map
View

Click here to load this message in the networking platform