I have extracted data from a text file with the help of a VB library file which was provided with the text file. The code did what is expected to do but have came across few problems, please bear with me I'm still a newbie to this:
1) Reading from line 20-877(used Notepad++), the aim was to add data from column A and column B, this works but from line 607 is on longer the case. Is there a way
to go around this?
2) When the code encounter an "empty space or # or & or *" it read them as values.
Is there a way to work around this so that the code can simply ignore them and pick the next value it see on the same line?
Any ideas on how to extract data from lines 885 and 907, respectively?
I have attached the data, code used and .bas as a pdf files used.
Thanks in advanced
Bookmarks