formula

[DaveL]

does anybody know how to distinguish between
Federal TaxId and a Social security number
in code

94-8329211 Taxid
565-31-8321 ssn both 9 characters
i recieve these without the dashes

the incomming field is by taxid or ssn 1 column not 2 columns

Thanks
DAVEL

 

[Israel]

does anybody know how to distinguish between
Federal TaxId and a Social security number
in code

94-8329211 Taxid
565-31-8321  ssn  both 9 characters
i recieve these without the dashes

the incomming field is by taxid or ssn 1 column not 2 columns

Thanks
DAVEL

Check out these sites:
http://www.socialsecurity.gov/history/ssn/geocard.html
http://en.wikipedia.org/wiki/Social_Security_number
http://www.socialsecurity.gov/employer/stateweb.htm

It looks like if the number starts with something less than or equal
to 772 then it's a SSN otherwise it's probably a taxid number but
that's just a guess after skimming these sites.
On another note, I hope those numbers you posted aren't really
someone's SSN and taxid number.

 

[DaveL]

Nope there just numbers i typed out of my head...
to match the formating of ssn and taxid

prob should of used ##-####### and ###-##-###

DaveL

does anybody know how to distinguish between
Federal TaxId and a Social security number
in code

94-8329211 Taxid
565-31-8321 ssn both 9 characters
i recieve these without the dashes

the incomming field is by taxid or ssn 1 column not 2 columns

Thanks
DAVEL

Check out these sites:
http://www.socialsecurity.gov/history/ssn/geocard.html
http://en.wikipedia.org/wiki/Social_Security_number
http://www.socialsecurity.gov/employer/stateweb.htm

It looks like if the number starts with something less than or equal
to 772 then it's a SSN otherwise it's probably a taxid number but
that's just a guess after skimming these sites.
On another note, I hope those numbers you posted aren't really
someone's SSN and taxid number.

 

[DaveL]

i'll just check the 3rd position if there is a - than ssn
else set to taxid
users have to format one of them

Thanks
DaveL

 

[DaveL]

oops 4th Position

If there's no hint WHOSE they are, what's the harm?

I'm sure 222-22-2222, 222-22-2223, etc. are Social Security Numbers. I
just don't know whose. i could name thousands more. There's no checksum
in them.

 

[Arne Vajhøj]

Nope there just numbers i typed out of my head...
to match the formating of ssn and taxid

prob should of used ##-####### and ###-##-###

Regex could be used to test for those patterns.

Arne

 

[Berryl Hesh]

Are you trying to validate a free form text entry? If so, use Regex -- you
can google for the correct match string quickly enough.

 

[Lee]

snip...
Check out these sites:http://www.socialsecurity.gov/histo.../www.socialsecurity.gov/employer/stateweb.htm

It looks like if the number starts with something less than or equal
to 772 then it's a SSN otherwise it's probably a taxid number but
that's just a guess after skimming these sites.
On another note, I hope those numbers you posted aren't really
someone's SSN and taxid number.

I have a taxid # that starts 222; so your thoughts on '772' are not
correct .

Unfortunately, if the numbers are unformatted -- no hyphens, as the
original OP said -- then I don't know of any way to differentiate
them.