Attached is a shortened version of the imported dataset. Please note how the data in the RAWDATA tab is grouped with multiple labels and values in a single cell.
In the JSN_FILTER tab I need to find the matching JSN code in the RAWDATA which is located in a single cell along with miscellaneous data. Once this code is located I need to obtain the "BTU / Hour" data. This data is located is single cell along with miscellaneous data as well. The "BTU / Hour" text here is followed by (5) spaces. Unfortunately, the "BTU / Hour" data is inconsistent. It's sometime 0, blank, or a (3) or (4) digit number. A blank should be interpreted as 0. Any help would be greatly appreciated.