This is good if all numbers are in the format of 1xxxxxxxxxx or +1xxxxxxxxxx but there were all kind of numbers with parentheses dashes and spaces... What I ended up with was replacing these:
\+1(\d{10})$
1(\d{10})$
With $1.
And these:
1-(\d{3})-(\d{3})-(\d{4})
(\d{3})-(\d{3})-(\d{4})
1 (\d{3})-(\d{3})-(\d{4})
\((\d{3})\) (\d{3})-(\d{4})
\+1 (\d{3})-(\d{3})-(\d{4})
\+1 \((\d{3})\) (\d{3})-(\d{4})
1(\d{3}) (\d{3}) (\d{4})
(\d{3}) (\d{3}) (\d{4})
With $1$2$3
Wouldn't changing the format of the column to telephone number format solve the problem that they are in different formats?