Extract Specific Data from a Cell after Certain Criteria

[JTB76]

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

[JTB76]

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.

[Luke_C · Accepted solution]

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.