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

Offline Yisroel Tech

  • Dansdeals Platinum Elite + Lifetime Gold Elite
  • ******
  • Join Date: Dec 2015
  • Posts: 922
  • Total likes: 77
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Monsey, NY
Re: Contacts Not Showing On Incoming Call - Help
« Reply #15 on: November 12, 2017, 02:04:47 AM »
I'm asking in my case. Which command will take out the 1s?
Oh. I've already posted that:
I'd do outlook CSV.

Then open in Google Sheets (or open in Excel and select all and C/P to Google Sheets.

In Google Sheets make a Find and Replace from 1\d{10} to $1

Then save back as CSV and import in Google (delete first all the contacts there).

Offline ilherman

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2013
  • Posts: 8164
  • Total likes: 25
  • DansDeals.com Hat Tips 34
    • View Profile
  • Location: Brooklyn
Re: Contacts Not Showing On Incoming Call - Help
« Reply #16 on: November 12, 2017, 02:08:44 AM »
Oh. I've already posted that:
Some contacts still showing the 1 I guess because they are stored with a plus + before the 1 and need to be removed differently?
You can say what you think when you think what you say.

Offline Yisroel Tech

  • Dansdeals Platinum Elite + Lifetime Gold Elite
  • ******
  • Join Date: Dec 2015
  • Posts: 922
  • Total likes: 77
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Monsey, NY
Re: Contacts Not Showing On Incoming Call - Help
« Reply #17 on: November 12, 2017, 01:30:16 PM »
Some contacts still showing the 1 I guess because they are stored with a plus + before the 1 and need to be removed differently?
Search for \+1(\d{10}) and replace with $1. But make sure "Also search within formulas" is checked.


Offline Yisroel Tech

  • Dansdeals Platinum Elite + Lifetime Gold Elite
  • ******
  • Join Date: Dec 2015
  • Posts: 922
  • Total likes: 77
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Monsey, NY
Re: Contacts Not Showing On Incoming Call - Help
« Reply #18 on: November 13, 2017, 06:49:07 AM »
Search for \+1(\d{10}) and replace with $1. But make sure "Also search within formulas" is checked.
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