I have created a test to verify sorting of column data in a table. The sorting test is working fine for all the columns except phone numbers. I am using swapping to sort them. The problem is each phone number have "-" in between them. Like 657-726-8272. This is making my test to fail.
How do I remove dashes from the phone numbers and store all the numbers to an array without the dashes? I don't wan't to replace the '-' with anything, but get rid of them, so that I will have it as 6577268272
My data is like
{657-726-8672, 647-726-8272, 667-776-8771, 257-736-8272}
I need it to be
{6577268672, 6477268272, 6677768771, 2577368272}
so that the sorted list will be
{2577368272,6477268272, 6577268672, , 6677768771}
Thanks in Advance