SSN Normalization

[Spedding]

Hi,

Has anyone written an SSN normalization function?

Thanks,

Joe

[AnthonyValidity]

Hi @Spedding ,

For the RegExMatch formulas, I think you would do them on seperate lines if you want to evaluate two different fields.  I wouldn't combine them with an AND.  I'm really not sure where the second part came from as it looks like the same formula twice?  It should look like this.  

RegExMatch(${TargetX_SRMb__SSN__c}, "^[0-9][0-9][0-9]\-[0-9][0-9]\-[0-9][0-9][0-9][0-9]$")

 This is how I would imagine your formula would look like in the Modify module under the action of Formula.

If you're unable to use the formula, I think the next step would be to get a Support ticket open so they can work further with you.

[Spedding]

Thanks Anthony.  Below is the exact formula that I am using.  DemandTools changed it to an "and" statement as show in the log - not me.  Anyway, thanks again!  I will open a Support Ticket.

RegExMatch(${TargetX_SRMb__SSN__c}, "^[0-9][0-9][0-9]\-[0-9][0-9]\-[0-9][0-9][0-9][0-9]$")

[AnthonyValidity]

Hi @Spedding ,

I thought that was a possibility.  Getting that error is strange only because it is working on my end with no issue.  

Glad you're getting to Support so they can take a look for you!