I have a problem when I import text files. I have created a procedure that extracts the information from a text file. That procedure works fine but when I want to convert the Text to Columns there is no suitable delimitator. The text file has a similar appearance as below:
Account Acount name
123 Abc Def Ghi
The problem is that I want to have the account name as one column but as there are spaces between the full account name I cannot use Space as a delimitator. I cannot use Fixed width as the information is dynamic (ie account number is incrementing). However, the account name cannot be longer than 22 characters (including spaces). Does anyone have an idea how to do this that is not by manually intervention?