Help with Regex parse

[lasmithfla]

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

[Thableaus · Accepted solution]

Hi @lasmithfla 

Would this work?

REGEX tool on parse mode with this expression

(\d{5})(.*)

Cheers,

[lasmithfla]

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

[Dynamomo]

@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.