Methods to import text

[kd5oyd]

I am importing text from files that have headers and other non-importable garbage. I can handle this with a complicated routine which processes each line before adding the text to the table, or I can create a temporary, properly formatted text file, import it with TransferText and then destroy the temp file. I prefer the temporary text file routine, but I’m curious which solution would be considered better form?

I'm the only programmer where I work and I am concerned that future programmers be able to quickly read and understand my work.

 

[THoey]

Not knowing that much about the data, if I was to be your replacement, I would prefer a function that parsed the data into a staging table and then loaded the records to your main table. Just make sure that you document the function well... Terry M. Hoey