I'm in search of a formula that will extract specific content that will vary in length. I'm working with a file that tags, these tags come in the following variety: 8=, 49=, 150=, etc. and the values following these tags can vary in length. the tags have a specific meaning but the positioning of the tags may not always be the same.
I need a formula (not VB Code, as I'm not proficient in VB), that will allow me to locate a tag and display it's value. Note: after each value there is a space to separate the tags, so the formula needs to find a specific tag (example: 52=20190522) and report only 20190522 by displaying everything after the 52= and up until the next space.
Because the file has multiple tags, I need it to identify specific tags and report from that tags = character to the next space which ends the tag presented and starts the next tag.
Sample Data:
8=FIX.4.2 9=123 35=7 56=Testfile 52=20190522-12:35:56
Expected Results:
Cell A1 = FIX.4.2
Cell A2 = 123
Cell A3 = 7
Cell A4 = Testfile
Cell A5 = 20190522-12:35:56
Thank you in advance for any help