First of all thank you for sending this bit of information.. Lengths are what I would definitely find useful. Most of the other information is pretty much gettable from an existing form titled CFG:Geography Country from the existing ITSM application, except for lengths (full length, country length, area lengths and local length).
Does this length include the country code or is it the length of the phone number without the country codes? I just ripped the file though to read just what I want.. And noticed that for e.g. Kuwait has a phone length of 10. I used to live in Kuwait and this is not true.. It is 10 IF you include the international dialing prefix of 965. ELSE it is 7. If you do not consider the the international dialing prefix, a lot of countries have a length of less than 10.. If you consider the dialing prefix many countries would have a length of greater than 10 - 12 in case of India for e.g.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of David Sanders Sent: Friday, March 14, 2008 7:45 AM To: [email protected] Subject: Re: CTM:People Phone number format.. ** Hi Joe Here is a small form def and data that may be of some use – it gives all country codes, national and international dialing prefixes and number lengths. It does not give normal number formatting which can vary greatly, but may be of some use to you. HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work ========================== ARS List Award Winner 2005 Best 3rd party Remedy Application See the ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk ---------------------------------------------------------------------------- -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Wednesday, March 12, 2008 7:39 AM To: [email protected] Subject: OT: CTM:People Phone number format.. This may well be off topic and I apologize for posting this to the list but I thought it may perhaps be the quickest way to get the most current information of what I want to know considering we have a global community here. I have a question about phone number formats across different countries.. specifically those listed below. I thought since we have users here from all over the globe some of you could contribute to what the format of Cell and land line numbers in your respective countries is like.. My whole purpose of doing this is I have a PeopleSoft integration that is work in progress. I'm dealing with phone numbers in a character field in PeopleSoft, that have been entered in a very 'free-text' format, and I was attempting to import that into Remedy using AIE. While building the interface to do so I am in the process of building some filters in the ARS that would cleanup the data. I need to build these filters in accordance with the information I get from here so all your inputs will be very useful to me.. I'm interested in your inputs in the format below because that will give me an idea of the length of the country code, the length of the area code, and finally the length of the local phone number (that may or may not be broken in 2 parts) CC COUNTRY Land Line Format Cell Phone Format --- ------------------------- --------------------- --------------------- FRA [France] + NLD [Netherlands] + IND [India] +91.99.9999.9999 +91.99.9999.9999 BMU [Bermuda] + SWE [Sweden] + DEU [Germany] + CAN [Canada] +1.999.999.9999 +1.999.999.9999 GBR [United Kingdom] +44. ARG [Argentina] + PRI [Puerto Rico] + USA [United States of America] +1.999.999.9999 +1.999.999.9999 BEL [Belgium] + AUS [Australia] + I understand that responses to this may not be too useful to everyone here so if you want to direct the response directly to me instead of the list, feel free to do so. At the same time, if you feel that the information generated through the responses I get here may be useful to you on similar endeavors, please feel free to request a format listing that I would get based on responses from this thread.. Cheers Joe D'Souza _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

