SpeedyKevin
New Member
- Joined
- Apr 26, 2019
- Messages
- 17
Hello all!
Have been a lurker for sometime and have found an incredible amount of useful threads here! However I can't seem to find anything that may help me with a notepad to excel macro ( I know theres a few but can't seem to get them to work )
So what I am trying to do is pull out Time stamps from a log (txt file). The log looks like this:
START STREAM @ 2019-01-09 10:35:04
STOP STREAM @ 2019-01-09 10:35:06
START STREAM @ 2019-01-09 10:35:13
0:00:02 - GREEN
0:00:04 - RED
0:00:05 - YELLOW
STOP STREAM @ 2019-01-09 10:35:21
The bit of info I am trying pull out are the timestamps related to either GREEN, RED, or YELLOW (see underlined lines).
I would also like to assign a button that uses Application.GetOpenFilename() so that the user can select the log file to import.
Also, if possible, I'd prefer the Timestamps and the Color be in different Columns/Rows like this. (I don't really need the hypen but if its too complex, we can keep it there)
<tbody>
</tbody>
Thanks in advance!
Kevin
Have been a lurker for sometime and have found an incredible amount of useful threads here! However I can't seem to find anything that may help me with a notepad to excel macro ( I know theres a few but can't seem to get them to work )
So what I am trying to do is pull out Time stamps from a log (txt file). The log looks like this:
START STREAM @ 2019-01-09 10:35:04
STOP STREAM @ 2019-01-09 10:35:06
START STREAM @ 2019-01-09 10:35:13
0:00:02 - GREEN
0:00:04 - RED
0:00:05 - YELLOW
STOP STREAM @ 2019-01-09 10:35:21
The bit of info I am trying pull out are the timestamps related to either GREEN, RED, or YELLOW (see underlined lines).
I would also like to assign a button that uses Application.GetOpenFilename() so that the user can select the log file to import.
Also, if possible, I'd prefer the Timestamps and the Color be in different Columns/Rows like this. (I don't really need the hypen but if its too complex, we can keep it there)
0:00:02 | - | GREEN |
0:00:04 | - | RED |
0:00:05 | - | YELLOW |
<tbody>
</tbody>
Thanks in advance!
Kevin