rodrigo412
Benutzer
- Beiträge
- 5
Hello i need to format lots of phone numbers in which the content would be like this
Festnetz|0202|528 72743
|040|987 44 10 oder 0170 465 45 33
41|(0)44|777 82 56
02273/54382|02273/5669344|Büro (these are two different numbers)
49|6151|13099-25
And I need it like this
Country code and then the number (notice the blanks)
+49 234 0987656
I am already using this expression
REGEXP_REPLACE(regexp_replace(REGEXP_REPLACE(concat(d.BUSINESS_PHONE),('[|]'),' '),('[-]'),' '),(' {2,}'),' ')
Thanks in advance
Rodrigo
Festnetz|0202|528 72743
|040|987 44 10 oder 0170 465 45 33
41|(0)44|777 82 56
02273/54382|02273/5669344|Büro (these are two different numbers)
49|6151|13099-25
And I need it like this
Country code and then the number (notice the blanks)
+49 234 0987656
I am already using this expression
REGEXP_REPLACE(regexp_replace(REGEXP_REPLACE(concat(d.BUSINESS_PHONE),('[|]'),' '),('[-]'),' '),(' {2,}'),' ')
Thanks in advance
Rodrigo