InfoPath Dev

 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)

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.

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))