Get String based on location

[andreahq]

Hi, I have a routing description and would like to extract the current location based on a location column, but not sure what is the best approach

Thank you

Input:

Output:

[Kenda]

Hey @andreahq 

In this case, I would recommend first using a Text to Columns tool to first split your data into rows. From there, you can use a Multi-Row Formula tool to create an id for each record within each Location group. Finally, use a Filter to keep only the rows where the Location matches the record id.

[atcodedog05]

Hi @andreahq 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Qiu]

@andreahq 
A bit different approach for your reference.