Regex Match

[mollieavett]

Hi I am trying to determine if the data in each row contains a social security number (format: ###-##-####). The text within the data is a long email message and I've been trying to use a RegEx_Match formula to see if any of them contain social security numbers. 

[alexnajm]

Regex_Match([Data], “.+\d\d\d-\d\d-\d\d\d\d.+”)

[Qiu]

@mollieavett 
Do you have any more specific requirement on the social security number format?

###-##-#### should be all digit?

Even so, some phone number might also be picked out as below.

?@*?@TEL?@0566-98-1781?@FAX?@0566-98-4794 *

[Deano478]

@mollieavett Here is my take on this just based on the format ##-###-####:

regex_match([YourField], '\b\d{3}-\d{2}-\d{4}\b')