Split the eight digit numbers in a column

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

Parse

Accepted answers

atcodedog05

Hib @bonadoni95

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

Workflow:

Hope this helps : )

8digits.yxmd

All comments

Priyanka_Ms

Hi Bona,

You can use the function Right() here.

Hope this helps!

Thanks and Regards

Priyanka

Right_chars.yxmd

atcodedog05

Hi @bonadoni95

Use regex tool parse mode like below.

Workflow:

Hope this helps : )

8digits.yxmd

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

Priyanka_Ms

@bonadoni95 , or use the formula like REGEX_Replace()

Thanks and Regards

Priyanka

Right_chars_2.yxmd

atcodedog05

Happy to help : ) @bonadoni95

Cheers and have a nice day!

bonadoni95

Thank you also for you suggestions! @Priyanka_Ms

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703