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
Solved! Go to Solution.
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!
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
thank you Brindham, I'll try with this solution.