I am importing a text file where the last piece of information is not the same length on each line. I would like to start by counting the length of the line before extracting the same 8 selected pieces of information from each line.
Right now if the last "field" on the first line has 7 characters the next line is imported correctly. If the last field has six characters it pulls in the first character of the next line.
The line lengths are 479, 480 or 481 characters.
We will be importing 50,000 lines.