InfoPath Dev

nope now its throwing it all off and not even the right number is populating at the moment....

that + is throwing it off.....scrap everything...... make the set a fields value : concat(substring(translate(., "()-. ", ""), 1, 2), "(", substring(translate(., "()-. ", ""), 3, 3), ") ", substring(translate(., "()-. ", ""), 5, 3), "-", ...

 Hi Julian,  I'm attaching a form that demonstrates how you can do this. The technique is a little tricky, but you can add the functionality to your own form by doing the following: Export the Iterator.xml file from the form's resource files Add it to your own form as an XML file data source Copy over the ...

also change the phone number pattern to a custom pattern: \+\d\(\d\d\d\) \d\d\d\-\d\d\d\d

OMG you are so close... Its now +1) 123-222-4444..... I need to either get rid of the +1) or get rid of the + & ) and have the - inserted. Thank you so much!!!!

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

Hello James: After reading the post "Format text with proper case in InfoPath" (http://goo.gl/FV3YAH), I found that this solution capitalize the first letter from the first word, but I need to capitalize the first letter from all words like "This Is A Test". Could you guide me with the script to do so? Thanks in advance.

Hi is there anyway you can copy and paste this so that I can copy and paste this in infopath.. I have tried typing this formula a few times and still get errors.. Thanks

do it like this....

ok I changed the last digit in the concat to a 6 and not a 4 and gained the last two digits back. However, it still looks very weird. i don't want the +. I just want it formated 1 (333) 444-7890.. Its now (+14) 222-635235