Parsing Text file to Excel
As a newbie its very difficult for me.
I request the gurus to kindly help to sort this problem.
The text file which is containing header and footers which are not required in workbook.
I have attached the text file and a formated data excel file.
Some one please give me a start ? help me.
Thanks in Advance.
Re: Parsing Text file to Excel
My best effort was to open your text file using Excel. It stops and asks for a delimiter during the import. You need to specify the delimiter as the | character. This is the shift key of the \ character. Then you text file at leaste comes in to separate cells and is similar to what you want. The next thing to do would be, remove unwanted rows of data, compressing it using Excel VBA.
I hope this gives you a start.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1