https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/102111.aspxSun, 12 Apr 2015 00:29:42 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:102111djm500https://www.infopathdev.com:443/forums/thread/102111.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=102111How do I change this original code if I want to end translation of the phone number to not include the brackets - like this. 123-456-7891?https://www.infopathdev.com:443/forums/thread/101887.aspxThu, 26 Mar 2015 15:05:10 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:101887Charlene0https://www.infopathdev.com:443/forums/thread/101887.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=101887nope now its throwing it all off and not even the right number is populating at the moment....https://www.infopathdev.com:443/forums/thread/101886.aspxThu, 26 Mar 2015 14:47:49 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:101886momk150https://www.infopathdev.com:443/forums/thread/101886.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=101886that + 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), "-", substring(translate(., "()-. ", ""), 8, 4)) condition is: Expression: not(xdUtil:Match(string(.), "\+\d\(\d\d\d\) \d\d\d\-\d\d\d\d")) AND Expression: string-length(translate(., "+()-. 0123456789", "")) = 0 AND Expression: string-length(translate(., "+()-. 0123456789", "")) = 0https://www.infopathdev.com:443/forums/thread/101884.aspxThu, 26 Mar 2015 14:38:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:101884momk150https://www.infopathdev.com:443/forums/thread/101884.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=101884also change the phone number pattern to a custom pattern: \+\d\(\d\d\d\) \d\d\d\-\d\d\d\dhttps://www.infopathdev.com:443/forums/thread/101883.aspxThu, 26 Mar 2015 14:30:10 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:101883Charlene0https://www.infopathdev.com:443/forums/thread/101883.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=101883OMG 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!!!!https://www.infopathdev.com:443/forums/thread/101882.aspxThu, 26 Mar 2015 14:28:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:101882momk150https://www.infopathdev.com:443/forums/thread/101882.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=101882concat(substring(translate(., "()-. ", ""), 1, 2), "(", substring(translate(., "()-. ", ""), 3, 3), ") ", substring(translate(., "()-. ", ""), 6, 3), "-", substring(translate(., "()-. ", ""), 9, 4))https://www.infopathdev.com:443/forums/thread/101880.aspxThu, 26 Mar 2015 14:23:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:101880Charlene0https://www.infopathdev.com:443/forums/thread/101880.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=101880Hi 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.. Thankshttps://www.infopathdev.com:443/forums/thread/101879.aspxThu, 26 Mar 2015 13:33:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:101879momk150https://www.infopathdev.com:443/forums/thread/101879.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=101879do it like this....https://www.infopathdev.com:443/forums/thread/101878.aspxThu, 26 Mar 2015 12:57:38 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:101878Charlene0https://www.infopathdev.com:443/forums/thread/101878.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=101878ok 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-635235https://www.infopathdev.com:443/forums/thread/101877.aspxThu, 26 Mar 2015 12:53:08 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:101877Charlene0https://www.infopathdev.com:443/forums/thread/101877.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=101877I did what you said but it came out as the following: (+14) 103-6352... it cut the last two numbers... Did I do something wrong?https://www.infopathdev.com:443/forums/thread/101876.aspxThu, 26 Mar 2015 12:50:38 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:101876momk150https://www.infopathdev.com:443/forums/thread/101876.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=101876should look like this.... see attachedhttps://www.infopathdev.com:443/forums/thread/101875.aspxThu, 26 Mar 2015 12:47:43 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:101875momk150https://www.infopathdev.com:443/forums/thread/101875.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=101875That didnt come out too user friendly not sure why. I spaced everything out but it all came together when i submitted it. private message me your contact info if you dont get it..https://www.infopathdev.com:443/forums/thread/101874.aspxThu, 26 Mar 2015 12:46:06 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:101874momk150https://www.infopathdev.com:443/forums/thread/101874.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=101874on the field you want to format put a rule: conditions: "Field you are formatting" does not match pattern "Phone Number Pattern" AND The expression "string-length(translate(., "()-. 0123456789", "")) = 0" AND Then run these actions: Set a fields value: The field you want formatted set it to the following value: concat("(", substring(translate(., "()-. ", ""), 1, 3), ") ", substring(translate(., "()-. ", ""), 4, 3), "-", substring(translate(., "()-. ", ""), 7, 4))https://www.infopathdev.com:443/forums/thread/101873.aspxThu, 26 Mar 2015 12:38:29 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:101873Charlene0https://www.infopathdev.com:443/forums/thread/101873.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=101873OMG!!! Thank you so much.. I have been pulling my hair out....https://www.infopathdev.com:443/forums/thread/101872.aspxThu, 26 Mar 2015 12:33:40 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:101872momk150https://www.infopathdev.com:443/forums/thread/101872.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=101872Yes I just got your message. I have your solution. Give me a few to get it out to you.. :)