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]

On Aug 21, 1:37*pm, "DaveL" <[e-mail]:

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

"Israel" <is**********@hotmail.comwrote in message
news:6e**********************************@k13g2000 hse.googlegroups.com...
On Aug 21, 1:37 pm, "DaveL" <[e-mail]:

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.

[MC]

On another note, I hope those numbers you posted aren't really

someone's SSN and taxid number.

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.

[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

"MC" <fo**************@www.ai.uga.edu.slash.mcwrote in message
news:OJ**************@TK2MSFTNGP05.phx.gbl...

>On another note, I hope those numbers you posted aren't really
someone's SSN and taxid number.

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.

[DaveL]

oops 4th Position

"MC" <fo**************@www.ai.uga.edu.slash.mcwrote in message
news:OJ**************@TK2MSFTNGP05.phx.gbl...

>On another note, I hope those numbers you posted aren't really
someone's SSN and taxid number.

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.

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

DaveL wrote:

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.
"DaveL" <dv*****@sbcglobal.netwrote in message
news:nF*******************@nlpi065.nbdc.sbc.com...

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

[Lee]

On Aug 22, 1:55 am, Israel <[e-mail]:

On Aug 21, 1:37 pm, "DaveL" <[e-mail]:
snip...
Check out these sites:http://www.socialsecurity.gov/histor...r/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.

--
Lee Silver
Information Concepts Inc.