US Phone Number - Formatting?

M

mike_ni

Have been messing about with this and havent been able to get it
working. Phone numbers are being stored as one long string on the
database. I have added an additional display field to the schema and
dropped this field onto the infopath form.

D/B 1234567890
Field should be (123) 456 7890

concat("(", substring(../@PhoneDisplay, 1, 3), ")", substring(../
@PhoneDisplay, 4, 3), " ", substring(../@PhoneDisplay, 7, 4)) and this
produces : (((()()( )( )
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

US Phone Number - Formatting on Infopath Form 0
Contact Phone Number Auto Format 0
How do I parse a phone number? 6
Format Phone Number Field VBA 1
Weird phone number formatting phenomenon 5
Formula to change Phone Number format 6
formatting phone numbers in Outlook Contacts... 1
Formatting Phone Number 9

Top