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:
one|two|three
four|five
six|seven|eight|nine
Results:
Hi @overhead_press
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?
@overhead_press
Expression would be for Left most
([^|]+)\|.*
Happy to help : ) @overhead_press Cheers and have a nice day!
@overhead_press another method using substring formula to find the left most word
My apologies I have one final question, for reference what if I want the second value from the left?
Here is the Regex
[^|]+\|([^|]+)\|?.*
