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

Offline Yisroel Tech

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2015
  • Posts: 1192
  • Total likes: 98
  • DansDeals.com Hat Tips 2
  • 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: 8301
  • Total likes: 38
  • 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 Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2015
  • Posts: 1192
  • Total likes: 98
  • DansDeals.com Hat Tips 2
  • 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 Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2015
  • Posts: 1192
  • Total likes: 98
  • DansDeals.com Hat Tips 2
  • 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

Offline myi

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Feb 2015
  • Posts: 12763
  • Total likes: 678
  • DansDeals.com Hat Tips 242
    • View Profile
  • Location: brklyn/Israel
Re: Contacts Not Showing On Incoming Call - Help
« Reply #19 on: January 02, 2018, 02:18:20 PM »
d stands for digits? While 10 being 10 digits?
Wonder if I could do the same thing by adding a +(plus) and a 1 in front of all my phone numbers in my contacts, would make it a lot eaiser to place phone calls while using Google hangouts or Google Voice( as all u.s. and Canadian numbers need to have the plus sign and the number one before dialing.)
  If it doesn't have a plus and and a 1 in front of the number I have to remember the 10 digit number and plug it in manually to call.
  What coding would I use to change all my numbers to a 1 and+? Thanks
Yes, \d is digits and {10} is a quantifier for the thing it is after.

You would replace (\d{10}) with +1$1:

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
Assuming I would use +1$1+1$2+1$3.
 Will try this as soon as I get near a computer.
Thanks yt?.

  Curious how would I avoid changing numbers which start with 05..
 Meaning don't want to change any Israeli numbers?
Don't try to be someone else , be who you are because everyone else is taken.

Offline talmid chuchem

  • Dansdeals Platinum Elite + Lifetime Gold Elite
  • ******
  • Join Date: Oct 2014
  • Posts: 858
  • Total likes: 26
  • DansDeals.com Hat Tips 4
    • 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?