Regex help required

[msantoso]

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

[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

[brindhan · Accepted solution]

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!

B

[msantoso]

thank you Brindham, I'll try with this solution.