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...
Chris Zangarine
Software Development Engineer
Pipeline Compliance System (PCS)
American Innovations