It depends on what version of Foxpro are you using.
I don't have any VFP versions older than VFP 6, so I can't test 3 or 5. But if you are using VFP 6 or higher you can create a table with all the fields related to your text file, and use this command to directly import the text file:
APPEND FROM temp.txt DELIMITED WITH CHARACTER |
If you are using FoxPro 2.x or lower, the DELIMITED WITH CHARACTER clause isn't available.
You can either have to parse the text file using low-level I/O functions like FOPEN(), FREAD(), FGETS() and so on. Or you can import it into a table, scan through each record, and parse the fields using functions like AT(), SUBSTR(), LEFT(), RIGHT().