I am trying to use the formula within Saved Search to extract multiple sub-strings from a text, and I am not sure if I am using the SUBSTR function right way.
Example: Here is my Text
'TEST12345:600000<br>TEST23456:30000<br>TEST34567:20000'
and I would like all the relevant information between ':' and <br> including the last value and should look line 60000 30000 20000
Is this possible with the formula?
Any thoughts?
Thank you