Hi guys !
I actually need some help with a phone number data.
My problem is that when new client create their profile, i use a API call to register them into RingOver, to do this, i need the phone number to be exactly in this french phone format : - “33xxxxxxxxx”
Client can actually enter there phone in an input in 3 differents way :
- 0x xx xx xx xx
- x xx xx xx xx
- 33 0x xx xx xx xx
so i need to find a way to be sure to convert every different format to this one “33xxxxxxxxx” in my database.
I try multiple time with “find and replace” or “regex” but it never work.
If anyone have some ideas, help would be appreciate.