Hi All - Need to extract data elements from a cell after certain criteria:
Compass - 1234 - RTO24
Compass - 1234 - RTO 24
In the example above, I want to only have RTO24 or RTO 24 extracted.
What is the best way to achieve this?
Thanks in advance.
James
Solved! Go to Solution.
Meant to say that I still need the original data in the cell its currently in, but need the RTO24 etc., in another separate cell as well.
Hi @JTB76
Here's two approaches, one with string functions and one with regex.
Side note, you might get quicker answers posting in the designer forum rather than server. This is more of a designer question.