I’m working with a table in Tibco Spotfire that contains FIX (Financial Information eXchange) messages stored as strings in a single column.

I need to split this column into multiple new columns, where each column represents a FIX tag and its corresponding value.

The format of the FIX messages is as follows:

tag number + "=" + value + special character ""

Does anyone have any tips or solutions for achieving this in Spotfire?

Thank you!

Example FIX message:

8=FIX.4.49=5935=034=51349=TEST52=20240920-14:46:02.37456=TEST10=181