Regex help required

Dear All,

i'm sorry to bother you with this simple question, but I can't get it right :-(

I have a list of phone numbers that requires some formating and I'm trying to use a Regex Parse method without the expected success.

The phone numbers have the following formats:

111/11111111

222 / 222222222

333/33 33 333

4444/444/444444

5555/ 5555/ 5555

666 666 666666

could you please help me write the regex phrase?

thank you

Myriam

Regex

Preparation

Accepted answers

brindhan

Hi @msantoso

You could use the tokenize method on regex with the expression [1234567890]+

This will split out only the numbers from your input.You can include '-' in the list if you want that included too.

Hope this helps, as I'm unsure how you'd like your output to look.

Cheers!

All comments

neilgallen

@msantoso

Myriam,

In these situation it's always best to include a sample of your starting data and your desired output. It's hard to know how to parse this correctly without the intended result.

Folks here will be happy to help, but you generally have to give them a direction to work towards!

msantoso

hi Neilgallen

of course ! here is a sample list.

Column 1 contains the original list and the following columns contain the outcome after the parse.

thank you

myriam

Regex for Phone numbers.xlsx

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703