International Phone Number FormattingInternational Phone Number Formatting

[Leatherpriest]

I've been searching and searching for an international phone number format calculation - Seems all I can find is US formatting. I would like it to be able to handle both if possible. . .. If anyone has some info on this, please do tell.

[danjacoby]

Use an "If" command -- such as, if(Left(telephone, 3) = "011" ... -- to determine if the phone number is an international number, then format accordingly.

Unfortunately, you can't set it to format too closely past the 011, as different countries have vastly different number formats, but at least it's a start.

HTH,

Dan

[GregFM]

One option is to use the Case function incombination with length function to anticipate all the possible total number of characters for the different countries' numbers:

Case(

Length(RawField) = 12, Left(RawField,3)&"/"&

Middle(RawField,4,3)&"/"&Middle(RawField,7,3)&"/"&Right(RawField,3),

Length(RawField) = 11, as above according to the convention of "/" or "-" or "()" you desire.

Or...

If the database has a field for the country name for the phone number, you cound substitute the test phrase Length() in the Case with

(Country=USA)or(Country=Canada), format this way,

(Country=Poland)or(Country=Germany, format that way, ...)

and so on.

GW