Clean up the phone number

hi everyone,

I need to clean up a phone number column which contains phone numbers but not only!

for the following cases, I need some help

- the name of the contact is preceeding the phone number. The length of the name is always different. the only similar case is that the phone number is preceeded with a blank space.

ex: Ms Marple 0176/123456789

- two phone numbers in the same cell separated with a dash or a single letter

thank you very much for your help

Myriam

Preparation

Accepted answers

msantoso

Hi David,

thank you so much for this recipe. It works for almost all the use cases I have in my file.

the strings that are still annoying me are:

0162/2870461 o. 0173/6456482

09071-54111 oder 0172/2470400

0151/12139881 - 0170/2257314

in these 3 cases I only retreive the second phone number, since the first one is considered as a name.

thank you

myriam

DavidP

For those 3 strings I would use a regex like this: (\d+)[/-](\d+)\s.+\s(\d+)[/[:alpha:]](\d+)

The new workflow then looks like this:

phone number parse.png

phone number parse.yxmd

All comments

DavidP

Hi Myriam,

A regular expression (Regex), like this should do the trick

phone number parse.png

phone number parse.yxmd

DavidP

Sorry, typo in the regex. It should look like this:

(.+\s)(\d+)[/\s](\d+)

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703