Extract data on the right-most delimiter

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

Regex

Accepted answers

You can use Regex tool parse mode like this.

Workflow:

Hope this helps : )

You can use Regex tool parse mode like this.

Workflow:

Hope this helps : )

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

Expression would be for Left most

([^|]+)\|.*

Hope this helps : )

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