Login Register






Thread Rating:
  • 0 Vote(s) - 0 Average


Diamond how to clean database? filter_list
Author
Message
how to clean database? #1
like any xyz database leak it got name,email,pass,xyz details , so i want to know how should i extract only email:pass in this situation any idea?


Reply

RE: how to clean database? #2
(09-07-2020, 08:18 PM)fsociety Wrote: like any  xyz database leak it got name,email,pass,xyz details , so i want to know how should i extract only email:pass in this situation any idea?


If it's in a clean csv format you can write a simple python script to just split by the comma symbol and take the 2nd and 3rd values.

[+] 1 user Likes Pikami's post
Reply

RE: how to clean database? #3
(09-07-2020, 08:50 PM)Pikami Wrote:
(09-07-2020, 08:18 PM)fsociety Wrote: like any  xyz database leak it got name,email,pass,xyz details , so i want to know how should i extract only email:pass in this situation any idea?


If it's in a clean csv format you can write a simple python script to just split by the comma symbol and take the 2nd and 3rd values.

If it's in SQL format, you should be able to export it as CSV as well.
[Image: fSEZXPs.png]

[+] 1 user Likes Dismas's post
Reply

RE: how to clean database? #4
(09-07-2020, 08:50 PM)Pikami Wrote:
(09-07-2020, 08:18 PM)fsociety Wrote: like any  xyz database leak it got name,email,pass,xyz details , so i want to know how should i extract only email:pass in this situation any idea?


If it's in a clean csv format you can write a simple python script to just split by the comma symbol and take the 2nd and 3rd values.

and if i have editor than ?? can i do something in that ?

(09-08-2020, 01:25 AM)Dismas Wrote:
(09-07-2020, 08:50 PM)Pikami Wrote:
(09-07-2020, 08:18 PM)fsociety Wrote: like any  xyz database leak it got name,email,pass,xyz details , so i want to know how should i extract only email:pass in this situation any idea?


If it's in a clean csv format you can write a simple python script to just split by the comma symbol and take the 2nd and 3rd values.

If it's in SQL format, you should be able to export it as CSV as well.

i have very less knowledgge of cleaning database... because never tried my self. i can open big database in emi editor can do sort email pass in that ?
(This post was last modified: 09-08-2020, 06:45 AM by fsociety.)

Reply

RE: how to clean database? #5
What is your database in? The type and Size.

It would take 30 less than 30 mimutes to make an exporter in Java 🙋‍♂️
Die  But Don't Lie
“Oh Abu Dharr! Don’t look at the smallness of the sin but look at the one you disobeyed.” Prophet Muhammad (pbuh)
[Image: p_237m2jx1.png]
Click for Free VPN

Reply







Users browsing this thread: 1 Guest(s)