Sql file

[Budol2]

I dont know if its good section, because i dont know russian language, if its bad please move the topic to the appropriate section.

I got question about DB wattpad.com I split the file into 500 parts so every file has 220mb i want copy specific emails from this database i was using notepad++ i choose for example interia.pl marks all and wanted copy them, but copied things weigh too much and email extractor is not able to load it so I cant copy the email I need.

Do u have any solution for this? how to copy specific emails from whole database ?

 

[corax]

grep "interia.pl" wattpad.sql

 

[Budol2]

grep "interia.pl" wattpad.sql

dont have linux right now, but this command will also select a word before interia.pl? for example blabla@interia.pl? or only interia.pl?

 

[corax]

http://gnuwin32.sourceforge.net/packages/grep.htm grep for windows. This command will be print full line with your keyword. If you want find only emails, you can use regexp like this https://stackoverflow.com/questions/2898463/using-grep-to-find-all-emails and grep flag -o.

 

[Budol2]

http://gnuwin32.sourceforge.net/packages/grep.htm grep for windows. This command will be print full line with your keyword. If you want find only emails, you can use regexp like this https://stackoverflow.com/questions/2898463/using-grep-to-find-all-emails and grep flag -o.

This command will be print full line with your keyword - in notepad++ u got the same when u mark specific word but it weigh too much.
If you want find only emails, you can use regexp like this - all emails? or specific? if all emails is usless for me, wattpad DB 200m+ emails it will take long long time.

Anyway thanks for advice

 

[corax]

or specific?

Example "[A-Za-z0-9._%+-]+@interia.pl"

 

[Budol2]

Example "[A-Za-z0-9._%+-]+@interia.pl"

This command working aswell in notepad++. After this command all emails contain interia.pl are selected, the problem is now how to mark only emails so i can copy them without full lines

 

[corax]

This command working aswell in notepad++. After this command all emails contain interia.pl are selected, the problem is now how to mark only emails so i can copy them without full lines

бл#ть, drop your notepad, notepad is shit.

 

[Budol2]

grep windows not working on windows10 ;x

 

[phant0m]

Why not write python script and loop trough all splited files ?
- Put all files in folder
- Loop trough them
- Use regex to search trough them

 

[Guron_18]

I dont know if its good section, because i dont know russian language, if its bad please move the topic to the appropriate section.

I got question about DB wattpad.com I split the file into 500 parts so every file has 220mb i want copy specific emails from this database i was using notepad++ i choose for example interia.pl marks all and wanted copy them, but copied things weigh too much and email extractor is not able to load it so I cant copy the email I need.

Do u have any solution for this? how to copy specific emails from whole database ?

google --> sqlrip

 

[hoanglan87]

you can install wsl for windows

 

[nexxxt]

to extract lines with spefic string you can use cmd.exe

FINDSTR "interia.pl" wattpad.sql >> output.txt