Split the eight digit numbers in a column

[bonadoni95]

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.

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

[Priyanka_Ms]

Hi Bona,

You can use the function Right() here.

Hope this helps!

Thanks and Regards

Priyanka

[atcodedog05]

Hi @bonadoni95 

Use regex tool parse mode like below.

Workflow:

Hope this helps : )

[bonadoni95]

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 · Accepted solution]

Hib @bonadoni95 

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

Workflow:

Hope this helps : )

[bonadoni95]

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

Bona

[Priyanka_Ms]

@bonadoni95 , or use the formula like REGEX_Replace()

Thanks and Regards

Priyanka

[atcodedog05]

Happy to help : ) @bonadoni95 

Cheers and have a nice day!

[bonadoni95]

Thank you also for you suggestions! @Priyanka_Ms