Is there a script that scan take text that is not column delimited and transfer each line into a separate record and each line where it is separated by a number of spaces inserts into a separate column.
For example the format of the txt file is as below but there are hundreds of lines.
TS123 TS123456ght TB12 TBH 0000
AS234 AF23424322 RI SSDFF EDE 7898979879
Each row maybe slightly different in the amount of data in it but i just want a way to import it.
It maybe that i need to state the first lot of data on a line goes into the first column, the second into a second column etc.