Alteryx Designer Desktop Discussions

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

Trying to pull an 8 digit number from a description column using the RegEx tool

F5_GL
6 - Meteoroid

Hello,

I am completely new to regex syntax. Could anyone help me figure out how to parse out the 8 digit numbers from the data below. The numbers will always start with 81 and be 8 digits but could be anywhere within the string.

 

81036015 Talisen Construction Corporation

PO 81036666 Systems source, inc Task chairs

TIMBER IT Consulting inv 4418 PO 81033202

 

Thanks!

3 REPLIES 3
cjaneczko
13 - Pulsar

If there arent any other 8 character digit sets in the any of your strings you can use (\d{8}) or if they all start with 81 then ([81]+\d{6}).

binuacs
20 - Arcturus

@F5_GL One way of doing this with the regex tokenize method

image.png

F5_GL
6 - Meteoroid

Thanks so much - so cool!

Labels