Start a new topic

Will Phone Numbers Import Formatted

Our database is set up with each Phone Type being formatted to #-###-###-#### x####.
I'm working on an import file where the phone numbers are many different formats.

During the import, will the phone numbers be pushed into the preferred format (at least, as much as possible) or will they just stay as-is?
Basically, do I need to pre-format the numbers?
JJ

1 Comment

I just did a test import and it converted (###) ###-#### and ########## to #-###-###-####.
If I add a regex dictionary to strip all non-digit characters (like http://www.omaticsoftware.com/Forums/tabid/108/aft/1694/Default.aspx), then it should end up pretty nicely.
JJ
Login or Signup to post a comment