Thank you for this great forum and your help!
Using Excel 2013
I am hoping my question is a simple one. I've done some searching
but it is very difficult to determine how to phrase my question in a
way that yields useful results.
I encountered a similar problem trying to title the thread :P
To give you an idea of the grand scheme of things, My goal is to take a log file
containing test data (see attached image) and drop it into an excel template
with a button that activates a macro which automatically converts text to columns, applies conditional formatting etc. to the Log data.
Here is where I am having difficulty;
as you can see in the picture, the event column contains a summary for each event that occurs. This information may simply be a "Lamp turned on" event or it could contain error codes and sub codes.
-I need to write a function that will recognize tif there is an error code in the event column
and if so, copy that error code value into the "error" column. If there is also a "param" value, this will need to be extracted into the parameter column.
-Once I've extracted those values into their respective columns I would like to then have excel find those codes in another table and populate the corresponding "Description" column with the description found in the error code table. I suspect this is a job for vlookup but since I'm already posting my first question I figure I'll ask about this one as well.
Please note that just looking for "100" in the event column will not do because various other events do occur that output 100 as a value, like "Lamp intensity 100". However, error codes will always be preceded by the word "Error " and followed by a comma. Also, the error codes range from single digit to 3 digit. What I mean by this is an error 3 is the number 3, not 003. I'm not sure if this makes it more difficult.
Thank you for your time and expertise!