Jan 25 2021 05:49 AM - edited Jan 25 2021 07:14 AM
Jan 25 2021 07:16 AM
The Import Text Wizard has two options: Fixed Width and Delimited. If your text file doesn't have a delimiter and if the columns don't have a fixed width, there is no way to divide the data into columns accurately - you will probably have to correct the data manually.
Jan 25 2021 09:00 AM
@Zan_Hanifee If you haven't used PQ before, it's not so easy to explain. But PQ has options to split a column when a character follows a number (digit). That's how you can determine the end of the first column, between 5 and A. Then, the newly created 2nd column is split for every time when there is a change from lower case character to an upper case character (space doesn't count as a character). That way, every time there is a capital letter (but not after a space) PQ splits the column.
It the data, however, is NOT so consistent, it may not work.