>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...


I don't have Clipper Summer '87 but I think FPW2.6 may be close enough so that the same things apply. At any rate, I reversed your steps. I went

USE myfile
lcfile="output.txt"
lcchar="|"
COPY TO &lcfile DELIMITED WITH &lcchar

and didn't get the same kind of file you describe above. Your delimiter replaces the quotation marks around the fields and each field is separated by a comma.

As far as getting only one line of output, my guess is that there is not a CR/LF between records. So without the comma to indicate a new field, and without a CR/LF to indicate a new record it can't properly process the data.

You may have to write a program to use low level function to read and parse your input file.

It's been a LONG time since I used Summer '87, but I think this should still hold true.

........Rich