How To Get Only Full Name, Phone Numbers And Address Out Of A Ton Of Information (Db) Request

[Yu Zhou]

Ребята, подскажите пожалуйста, как вытащить из тонны информации только фулл нейм, тел номера и адрес. Пробовал через notepad++, но не получается. Помогите пожалуйста.


Guys, please advise how to get out of a ton of information only full name, phone numbers and address. Tried notepad++, but it does not work. Help please

 

[gace2k]

I suppose that your source is TXT or CSV files, when there is too much data it will not work for you to search by parameters or it is very complicated, you would have to install a plugin, personally if there are up to 1M records I use SUBLIME TEXT, you can install plugins and it is fast , but if there are more records, I definitely pass them to a MySQL table, import them with DBeaver and there I can build complex queries or by specific parameters, install XAMPP or WAMP so you don't get complicated with MySQL


In the event that the records do not have the same structure, then I recommend MongoDB, also import the data with COMPASS that comes with MongoDB


Luck

 

[Haides]

depends on how the file is structured

 

[fonirik833]

I heard elastic search works for google style search. I am still trying to figure out how to import all data files to elastic search

 

[Soup]

You can go for glogg too

You do not have permission to view link Log in or register now.

 

[Yu Zhou]

Thanks everyone for the reply!

 

[LeonOn]

Download XAMPP - installing 1 minute, upload DB in MySQL

 

[3dw4rdsn0w]

If you are on Linux, you can use grep, sed, tr, etc...

For example:

You have the following data inside the example.ext file

112963109 | 114310514 | 1 | Linus | Torvalds | linustorvalds@gmail.com | RUA JACINTO BEHI PALLI | 152 | Casa 1337 | RIO DE JANEIRO | BAHIA | 02961-130 | 2021-09-26 | 16052 06:19:02.538331+00 | (88)99999-9999

If you are interested in name, last name, email and full address and phone number you could just do

grep -i "linus" example.ext | grep -i "torvalds" | sed 's/|/ /g' | tr -s " " | cut -d " " -f 4,5,6,7,8,9,15

You should get:

Linus Torvalds linustorvalds@gmail.com RUA JACINTO BEHI PALLI 152 Casa 1337 (88)99999-9999

It is faster and consumes less resources than importing the whole data to a handler software.

 

[Yu Zhou]

Thanks guys for the help. Please tell me how to extract a full name from a 1000 PDF file, age (for example, from 30 years old and above), phone number and specialty