Tax id validation rule

Hi,

I need to validate tax id field with out being junk.

For example it cant be 9999999999 or 2222222222 or 3333333333.

I know we have to use regex function for particula format but all numbers cant be same

Thanks

June 7, 2011
·
Like
0
·
Follow
0

Best Answer chosen by Admin (Salesforce Developers)

Akhilesh.jaipur
Hi,

while using regx its very easy to implement

REGEX(fieldName, "[0]{4,}|[1]{4,}|[2]{4,}|[3]{4,}|[4]{4,}|[5]{4,}|[6]{4,}|[7]{4,}|[8]{4,}|[9]{4,}")

will report you whenever user tries to enter similar digits more than 3 times

if you want to allow less or more repetitive chars then simply change the " {4,} " to like "{3,}" only two same chars or "{6,}" for 5 same chars

Thanks
Akhilesh

June 7, 2011
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

Tax id validation rule

You need to sign in to do that.