It's been a while since i've been here; missed me??? ;)
I am working on a database project for a traveling agent. For that project I am creating a form where e-mailaddresses and phonenumbers can be entered.
As far as I know, phonenumbers can be entered in following forms:
and of course; to make international numbers valid, it must be possible to add +31 or 0031 to the front of the number:
I would like a routine to validate these kind of numbers, and preferably convert these numbers to one format. Can anyone help me creating this using regular expressions or so?
I would like to have a quick answer, so i can go on with my project, and any comment is apreciated.