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.
Solved! Go to Solution.
RegEx_Match([Field], ".*\d{7}.*") should work
Thank you! This worked!