on 07-21-2009 5:41 PM
We are a global company and quite often have different formats for our phone and fax numbers. What kind of formula do I need to create to properly format the phone number depending on a certain country?
Thanks!
You could try something similar in a formula:
select {country}
case "usa", "canada":
picture({phone#}, "(xxx) xxx-xxxx")
case "uk":
picture({phone #}, "xx-xx-xxxx-xx");
For USA & Canada, the phone number will display as (907) 123-4567. The number of digits in the phone number should match the number of x in the formula.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.