asked on VB Strip data from CSV log
Hi,
Using VB6 I am trying to open a log file and then display in a textbox (txtOutput) certain information. I have included a csv as an example.
I need to open the csv and search for the 1st instance of "PBSTAT_START". The timestamp for that line should be returned. If there is no such line then "NO MOVES" should be returned and the sub should exit.
If "PBSTAT_START" is found then the file should be searched for the number of lines which have "PBSTAT_START".
Does this make sense?
Cheers
Using VB6 I am trying to open a log file and then display in a textbox (txtOutput) certain information. I have included a csv as an example.
I need to open the csv and search for the 1st instance of "PBSTAT_START". The timestamp for that line should be returned. If there is no such line then "NO MOVES" should be returned and the sub should exit.
If "PBSTAT_START" is found then the file should be searched for the number of lines which have "PBSTAT_START".
Does this make sense?
Cheers
Visual Basic Classic
Last Comment
Martin Liss
You forgot the attachment.
ASKER
Sorry!
2011-07-16-LogFile-HK1.csv
2011-07-16-LogFile-HK1.csv
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
I updated the code above.