Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

Extract data on the right-most delimiter

overhead_press
8 - Asteroid

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
8 REPLIES 8
atcodedog05
22 - Nova
22 - Nova

Hi @overhead_press 

 

You can use Regex tool parse mode like this.

 

Workflow:

atcodedog05_0-1641576315226.png

 

Hope this helps : )

 

overhead_press
8 - Asteroid

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

binuacs
17 - Castor
atcodedog05
22 - Nova
22 - Nova

Hi @overhead_press 

 

Expression would be for Left most

 

 

([^|]+)\|.*

 

 

Hope this helps : )

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @overhead_press 

Cheers and have a nice day!

binuacs
17 - Castor

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

 

binuacs_0-1641577651901.png

 

overhead_press
8 - Asteroid

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

atcodedog05
22 - Nova
22 - Nova

Hi @overhead_press 

 

Here is the Regex

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

 

Hope this helps : )

 

Labels