Clean-up phone numbers in table

code4romania / Alt-TaskBucket

Mozilla Public License 2.0

0 stars 0 forks source link

Clean-up phone numbers in table #3

Closed overeha closed 4 years ago

overeha commented 4 years ago

We need

all the phone number to use the same format with ”00” in front of the country code, not +. Please clean up and format all hone numbers.

This is a collaborative document - please be careful with the data and other people working on it.

https://drive.google.com/file/d/1Gjmgo2qoh1qEavgl2Muv1k2NJ08IjFij/view?usp=sharing

alexandrutabolcea commented 4 years ago

ma ocup eu

alexandrutabolcea commented 4 years ago

daca va mai fi nevoie si pe viitor, o formula destul de dummy pentru o normalizare a numerelor de telefon:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(G2, "-", ""), "/", CHAR(10)), ", ", CHAR(10)), ")", ""), "(", ""), ".",""), ",",""), " ", ""),"+","00")

tudoramariei commented 4 years ago

Fantastic! Thanks a lot @alexandrutabolcea Closing this now