count of numerics/digits with no space in between

[Idyllic_Data_Geek]

I have a requirement where I will like to idenitfy certain value types in a field. A user might input ssn, loan # or other personal information by mistake so I need to identify it and take an action. if I use the below regex statement, the issue I have is that it returns ther esults where there are 7 digits but there are spaces in between

REGEX_CountMatches([Payee addr 1], '[0-9]') > 7 is also returning 0000 169TH ST APT 000 in data results

where as I only want to get the values where is actually like '0000000

Any thoughts?

[T_Willins]

HI @Idyllic_Data_Geek,

Try using the formula REGEX_CountMatches([Payee addr 1], '\d{7,}') >=1   

This will look for any substring with 7 or more consecutive digits.  The >=1 is counting if there is one or more matches.  It will return a 0 for false or -1 for true.