471,330 Members | 1,440 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,330 software developers and data experts.

formula

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


Aug 21 '08 #1
8 1142
On Aug 21, 1:37*pm, "DaveL" <dvs_...@sbcglobal.netwrote:
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.

Aug 21 '08 #2
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" <dvs_...@sbcglobal.netwrote:
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.
Aug 21 '08 #3
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.

Aug 21 '08 #4
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.

Aug 21 '08 #5
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.

Aug 21 '08 #6
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
Aug 21 '08 #7
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


Aug 22 '08 #8
Lee
On Aug 22, 1:55 am, Israel <israeldip...@hotmail.comwrote:
On Aug 21, 1:37 pm, "DaveL" <dvs_...@sbcglobal.netwrote:
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.

Aug 22 '08 #9

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by alex | last post: by
3 posts views Thread by Mike | last post: by
11 posts views Thread by Brian VanPelt | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.