Chris,
Sounds like you're working with the same file output I had in my very last Clipper app. What I did was append the entire text file into a table with a single field which was long enough to hold a complete record (in one case I actually needed 3 fields, given the 254 char. limit). Then I parsed the line looking for the text between each "|" character. In VFP you can use AT('|', MyField, 4) to get the fourth occurence of "|". In Clipper I think I had to use successive substrings. Anyway, I'd parse each field and pop the results into the correct field of my final table.
HTH
Barbara
>This is my text file...
>
>1Test Point|||C|Y|||H|||
>ID|TP106||C|Y|||T|||
>LOC|EAST END OF THE RIVER||C|Y|||T|||
>ROUTE|COMPLIANCE||C|Y|||T|||
>DATE|DATE()||D|Y|||T|||
>TIME|TIME()||T|Y|||T|||
>STRUC IRF||1.083|V1|N|20mV||M|||
>CASE PS||1.759|V1|N|20mV||M|||
>CASE IRF||1.023|V1|N|20mV||M|||
>INSUL PS||1.650|V1|N|20mV||M|||
>INSUL IRF||1.295|V1|N|20mV||M|||
>UDF1||.865|V2|N|20mV||M|||
>RTNUM|2||CH|Y||||||
>-
>
>This is my command...
>
>lcfile="incoming.txt"
>lcchar="|"
>APPEND FROM &lcfile DELIMITED WITH &lcchar
>
>It's putting the first line of the text file in the first field of the first record of the table, and that's it. If you're seeing what I'm not, please let me know...