Extract phone numbers from a chat history

S

soxtexo

Newbie

Sep 13, 2017

24

3

• Feb 14, 2018

• #1

Hey guys,

I've got a chat history from a WhatsApp group.

The structure of the text looks like:

....
05.12.17, 06:55:25: ‎‪+49 173 71696**‬ hat die Gruppe verlassen
05.12.17, 06:56:25: ‪+49 176 642603**‬: Hast du noch einen guten ab 21 Uhr ?
05.12.17, 06:57:04: ‪+49 176 706610**‬: Heute muss rasiert werden
05.12.17, 06:57:25: ‪+49 1516 15348**‬: chillt
...

Now I would like to extract all the numbers out of this txt. file
I would like to get a list of numbers where every number is unique with no double numbers.

Does anyone have an idea what's the easiest way to do this? Thanks you guys!

 

bmbsa

Junior Member

Jun 25, 2014

120

20

• Feb 20, 2018

• #2

I believe you can do this in less than 5 minutes using regex (notepad++ or any other text editor) to extract the numbers + excel to remove duplicates

 

Builder Dave

Power Member

Nov 4, 2017

653

654

• Mar 2, 2018

• #3

Yep, regular expression should do the job really quickly.

 

Sudarshan Kar

Power Member

Apr 27, 2017

674

350

• Mar 23, 2018

• #4

If you are familiar with programming, this should be a piece of cake.

 

B

bitBot

Newbie

Apr 8, 2018

8

0

• Apr 8, 2018

• #5

soxtexo said:

Hey guys,

I've got a chat history from a WhatsApp group.

The structure of the text looks like:

....
05.12.17, 06:55:25: ‎‪+49 173 71696**‬ hat die Gruppe verlassen
05.12.17, 06:56:25: ‪+49 176 642603**‬: Hast du noch einen guten ab 21 Uhr ?
05.12.17, 06:57:04: ‪+49 176 706610**‬: Heute muss rasiert werden
05.12.17, 06:57:25: ‪+49 1516 15348**‬: chillt
...

Now I would like to extract all the numbers out of this txt. file
I would like to get a list of numbers where every number is unique with no double numbers.

Does anyone have an idea what's the easiest way to do this? Thanks you guys!

Click to expand...

Use something like "\+[0-9]{2} [0-9]{3,4} [0-9]{4}/g" in any regex editor

 

K

kullaravi

Junior Member

May 1, 2011

103

23

• Jun 7, 2018

• #6

Regex would be the easiest way to go..

 

HoNeYBiRD

Elite Member

May 1, 2009

10,187

12,580

• Jun 7, 2018

• #7

If the data is formatted like that, you can split the lines into columns by the "+" and ":" delimiters in Excel, so you'll have the phone numbers in one column, what you can copy-paste to Notepad++ and use the TextFX plugin to remove duplicates.

 

Melos

Junior Member

Apr 22, 2018

110

43

• Jun 7, 2018

• #8

You can try this one http://www.convertcsv.com/phone-extractor.htm .

I did have a similar case, but I only needed to extract email from a text and some tools from Google did they heavy work for me.

 

MunnyMachine

Failed to resolve dispute

Dec 8, 2015

197

46

• Jun 7, 2018

• #9

or Pay someone like 5 bucks to write a quick script

 

P

pinkpower123

Junior Member

Mar 29, 2014

103

19

• Jun 9, 2018

• #10

What service?

 

I

Innovative-SEO

BANNED

Apr 29, 2019

19

0

• May 1, 2019

• #11

I can do this. Contact me if you can.

 

timothywcrane

Supreme Member

Apr 25, 2009

1,339

742

• Jun 17, 2019

• #12

if you are looking to get into text and data manipulation, automation, or data vi... I recommend Python... check out split() function.