Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop 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
20 - Arcturus
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
20 - Arcturus

@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