General

Re: TIN number validation

DebiScott — Wed, 10 Dec 2014 20:48:16 GMT

Close- it gives me 3 digits followed by 6 digits xxx-xxxxxx instead of 2 followed by 7 xx-xxxxxxx

Can you adjust?

Ok I figured it out - trial and error and reading - gotta love Google.

TIN = concat(substring(translate(., "- ", ""), 1, 2), "-", substring(translate(., "- ", ""), 1, 7))

donstephen — Mon, 01 Dec 2014 05:19:22 GMT

Hi Debi,

I have a formula here which you could try:

concat(substring(translate(., "- ", ""), 1, 3), "-", substring(translate(., "- ", ""), 4, 7))

Please let me know if this works for you.

DebiScott — Tue, 25 Nov 2014 17:28:40 GMT

I have the formula's for SSN validation and formatting but my users want to use TIN numbers.

This is what I have for SSN (xx-xxx-xxxx)

concat(substring(translate(., "- ", ""), 1, 3), "-", substring(translate(., "- ", ""), 4, 2), "-", substring(translate(., "- ", ""), 6, 4))

I need TIN (xx-xxxxxxx)