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