Regex Match

Question

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.

PolicyCompliance_case_studies_Enron.csv

Deano478 · Answer

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

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

Qiu · Answer

@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 *

alexnajm · Answer

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