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

Help with Regex parse

lasmithfla
6 - Meteoroid

I have an field that has inconsistent data types and struggling with Regex to parse these into 3 columns

 

AreaName

23000

23000a

23123b

24560_1

25555.a

 

I need to get the first 5 numbers in a field and then everything after that.  I've p

3 REPLIES 3
Thableaus
17 - Castor
17 - Castor

Hi @lasmithfla 

 

Would this work?

 

24-10-Regex.PNG

 

REGEX tool on parse mode with this expression

 

(\d{5})(.*)

 

Cheers,

lasmithfla
6 - Meteoroid

Yes thank you so much... I was so close to that but wasn't getting the . and * right....

Dynamomo
11 - Bolide

@lasmithfla 

Looks like you didn't finish your thought or it got cut off.

do you mean 1st 5 numbers in one field and the rest in a second field?

if so, you can use the Regex tool for this.  

The regular expression would be \d{5} for the first part for 5 numbers and .* for the rest.

What you want to parse out needs to be in parentheses to mark the groups.

Dynamomo_0-1571960622415.png

Labels