Author Topic: Contacts Not Showing On Incoming Call - Help  (Read 2671 times)

Offline talmid chuchem

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Oct 2014
  • Posts: 1130
  • Total likes: 67
  • DansDeals.com Hat Tips 5
    • View Profile
Re: Contacts Not Showing On Incoming Call - Help
« Reply #20 on: January 04, 2018, 12:57:39 AM »
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?