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

Luke_C

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.

New Workflow3.yxmd