>>>I have a text file that contains a header record and details record. How do I append the first textfile record into my table using APPEND FROM and how do APPEND FROM the remaining detail records into another table? Or is there a better way? thanks
>>
>>Would APPEND TYPE CSV work for you? It ignores the first record.
>
>My file needs to be brought in as SDF actually. I think capturing my detail record through SDF will work because I can always delete the first record in my DETAIL_TABLE, however; how would I capture the first record which needs to goto HEADER_TABLE? My files are not comma seperated unforunately.
>
>Nick
How big is your file? If it's relatively small you can do
lcStr = filetostr('myFile.txt')
lnLines = alines(laLines,lcStr)
lcHeaderRecord = laLines[1]
and process it.
If it's not broken, fix it until it is.
My Blog