Contact phones in different formats

[bsinclair]

Hi,

I am testing this app and I have a doubt/suggestion (maybe). In my contact list (almost 1,000 names), I have phones that came from different sources, like own created, syncked from google, syncked from exchange and so on. My problem is that, they came in several different formats. Some examples are:

021 11 9876-5432
021 11 98765432
02111 98765432
0211198765432
011 9876-5432
01198765432

You can see they are all the same number. I would like to convert all off them to the same format (easier for my contact history match), and that willbe 0211198765432. Explaning, 021 is calling card company, 11 (or 011) is city code and 98765432 is the phone number.

Right now, the only way I found was to create several rules. Can it be done with just one?

My suggestion, create a contextual parameter named {clearphone}, that will be only the digits, removing everything else. This way, I could create a rule to change it to 021{clearphone}[0,10] and this will match every combination I might have.

[admin]

Hi bsinclair,

{phone} is already in clear format which contains digits, a leading '+' (if any), and/or some commas.