You can create cursor/table with structure matching the text file and use APPEND FROM DELIMITED command to append records from the text file to it. For example,
CREATE CURSOR temp ( ;
C1 C(20), c2 C(20), f1 C(10), c3 C(16), c4 C(12), ;
n5 N(9,2), n6 N(9,2), n7 N(9,2), n8 N(9,2), n9 N(9,2), n10 N(9,2))
APPEND FROM myfile.txt DELIMITED WITH CHARACTER "|"
>Hey there!
>
>Could anyone help me? I need to parse text from .RPT file. When I use the import wizard from Foxpro, it places the data into a foxpro table with a character field that is 117 CHARACTERS long. All the fields are delimited by pipes (|). I tried to use the ALINES, but was unsuccessful. Could anyone help? Here is an example of what it looks like in the imported table:
>
>
>AACUVI|A-Acuvision||(425)820-1400|KELLIE|345.93|58.00|180.29|252.20|-923.20|-86.78
>
--sb--