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

Split the eight digit numbers in a column

bonadoni95
6 - Meteoroid

Hello everyone, an Alteryx newbie here. Really need assistance from the seniors/masters here.

 

I want to split the eight digit numbers located at the end of the strings in this specific column to a new column for VLOOKUP-ing purposes.

bonadoni95_0-1634887958945.png

I was thinking of using the Text to Columns tool, but the delimiters in each row are different.

 

Kindly advise on the above matter. Thank you in advance.

 

Bona

 

8 REPLIES 8
Priyanka_Ms
8 - Asteroid

Hi Bona,

 

You can use the function Right() here.

Priyanka_Ms_0-1634888475761.png

 

Hope this helps!

 

Thanks and Regards

Priyanka

 

atcodedog05
22 - Nova
22 - Nova

Hi @bonadoni95 

 

Use regex tool parse mode like below.

 

Workflow:

atcodedog05_0-1634888558566.png

 

Hope this helps : )

 

bonadoni95
6 - Meteoroid

Thank you, atcodedog and Priyanka! Really appreciate the help.

 

Additionally, if you notice, there are some rows in which the eight digit number is located not at the end of the strings but instead, in the middle.

 

Is there any way to split those numbers together with the eight digit pattern in the other rows?

 

Thank you,

Bona

atcodedog05
22 - Nova
22 - Nova

Hib @bonadoni95 

 

Change the regex like below to extract 8 digits anywhere in the string.

 

Workflow:

atcodedog05_0-1634889047293.png

 

Hope this helps : )

 

bonadoni95
6 - Meteoroid

Thank you so much! I have just tried this and it worked wonderfully!

 

Bona

Priyanka_Ms
8 - Asteroid

@bonadoni95 , or use the formula like REGEX_Replace()

 

Priyanka_Ms_0-1634889381688.png

 

Thanks and Regards

Priyanka

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @bonadoni95 

Cheers and have a nice day!

bonadoni95
6 - Meteoroid

Thank you also for you suggestions! @Priyanka_Ms

Labels