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 |
Solved! Go to Solution.
Thank you so much! What would the expression look like if I want the left-most value?
Happy to help : ) @overhead_press
Cheers and have a nice day!
My apologies I have one final question, for reference what if I want the second value from the left?