Extract data on the right-most delimiter

[overhead_press]

I have a bunch of data in rows with the "|" delimiter and I want to extract the data at the end. How would I go about doing this? Thanks in advance! 

Example:

Column 1

one|two|three

four|five

six|seven|eight|nine

Results:

Column 1

Three

five

nine

[atcodedog05 · Accepted solution]

Hi @overhead_press 

You can use Regex tool parse mode like this.

Workflow:

Hope this helps : )

[overhead_press]

Thank you so much! What would the expression look like if I want the left-most value? 

[binuacs]

@overhead_press 

[atcodedog05]

Hi @overhead_press 

Expression would be for Left most

([^|]+)\|.*

Hope this helps : )

[atcodedog05]

Happy to help : ) @overhead_press 

Cheers and have a nice day!

[binuacs]

@overhead_press another method using substring formula to find the left most word

[overhead_press]

My apologies I have one final question, for reference what if I want the second value from the left? 

[atcodedog05]

Hi @overhead_press 

Here is the Regex

[^|]+\|([^|]+)\|?.*

Hope this helps : )