I am capturing the data output from a CO2 incubator, using TeraTerm, into a log file. An example of the data is below. I would like to be able to use VBA to copy the fourth value after each asterisk and nothing else, and paste it into an excel worksheet. Can anyone steer me in the right direction? Thanks for any help here!
-Penny
*
0503
0012
0503
0507
0000
0000
Current CO2: ,503
Predicted CO2: ,503
Displayed CO2: ,507
Predictor Gain: ,0
CO2 injection (0/1): ,0
CO2 report errors: ,0
M400 read errors: ,0
Bad or prohibited cmd: ,0
Busy retries: ,0
Loop count: ,2494
----------------------------
*
0504
0012
0503
0507
0000
0000
Current CO2: ,504
Predicted CO2: ,503
Displayed CO2: ,507
Predictor Gain: ,0
CO2 injection (0/1): ,0
CO2 report errors: ,0
M400 read errors: ,0
Bad or prohibited cmd: ,0
Busy retries: ,0
Loop count: ,2495
Bookmarks