I have this text file which shows data like
GL CODE. GL DISCRIPTION. DEBIT. CREDIT
14355 Mt two wheele. 67895000. 9876555
15367 MT CON LOAN. 8769762 7655444
14567. MT NON CON. 4356278. 4526727
but the problem is there is too much unwanted data prior to this and after this. I tried text import wizard but there are too many files that makes it time consuming...I also tried the code suggested in similar post and even tried to modify it but no succese. I want code discription debit and credit in different column...GL CODE is of five digits and then there is text again there are figures in debit and credit
And there is also one thing there are total of 4 column sometimes I require Code debit and credit and sometimes all four so code must be flexible
GL CODE. GL DISCRIPTION. DEBIT. CREDIT
14355 Mt two wheele. 67895000. 9876555
15367 MT CON LOAN. 8769762 7655444
14567. MT NON CON. 4356278. 4526727
but the problem is there is too much unwanted data prior to this and after this. I tried text import wizard but there are too many files that makes it time consuming...I also tried the code suggested in similar post and even tried to modify it but no succese. I want code discription debit and credit in different column...GL CODE is of five digits and then there is text again there are figures in debit and credit
And there is also one thing there are total of 4 column sometimes I require Code debit and credit and sometimes all four so code must be flexible