Search Forum Home   Mainstream Forums  General Discussion  Australian Phon...  Australian Phone number Fix (2.1)   ginnivanj 26 posts Joined 4/15/2008 Australian Phone number Fix (2.1) Posted: 17 Jun 08 8:49 PM If there are any other Australian users of splendid CRM, the phone number validation doesnt work for a number formatted like: +61 8 9000 0000 The regular expression to use to fix this is: ^(?:(?:[\+]?(?[\d]{1,3}(?:[ ]+|[\-.])))?[(]?(?[\d]{1,3})[\-/)]?(?:[ ]+)?)?(?[a-zA-Z2-9][a-zA-Z0-9 \-.]{6,})(?:(?:[ ]+|[xX]|(i:ext[\.]?)){1,2}(?[\d]{1,5}))?$ The table to update is: FIELD_VALIDATORS Hope this helps someone. The reason it fails is in the US the area code is 3 digits. In australia it is only 1. That is all this changes jammin 6 posts Joined 2/20/2007 Re: Australian Phone number Fix (2.1) Posted: 24 Jun 08 11:06 PM Hmm thanks for this, but I get an error in 2.1 ^(?:(?:[\+]?(?[\d]{1,3}(?:[ ]+|[\-.])))?[(]?(?[\d]{1,3})[\-/)]?(?:[ ]+)?)?(?[a-zA-Z2-9][a-zA-Z0-9 \-.]{6,})(?:(?:[ ]+|[xX]|(i:ext[\.]?)){1,2}(?[\d]{1,5}))?$ is not a valid regular expression. Anyone have another updated one?  Page 1 of 1   Mainstream Forums  General Discussion  Australian Phon... Flat View Tree View Oldest To Newest Newest To Oldest