We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

If formula if the data starts with a number with a certain number of characters

kjvan026
7 - Meteor

I have a large amount of data where I need to identify if it contains a number that has 7 digits (it could be any number with 7 digits).  So like this:

 

9943170 Documentation

8734329 Diary

Diary Entries

2021_Diary

Diary 3802862 0102

2021_89125

3893231

 

I would need it to identify the green ones. 

 

My ultimate goal is to only have the 7 digit number if it has the 7 digit number, but I know the formula past the identification stage.

 

 

2 REPLIES 2
alexnajm
18 - Pollux
18 - Pollux

RegEx_Match([Field], ".*\d{7}.*") should work

kjvan026
7 - Meteor

Thank you! This worked!

Labels
Top Solution Authors