+- Sinisterly (https://sinister.li)
+-- Forum: General (https://sinister.li/Forum-General)
+--- Forum: The Lounge (https://sinister.li/Forum-The-Lounge)
+---- Forum: Serious Discussion (https://sinister.li/Forum-Serious-Discussion)
+---- Thread: how to clean database? (/Thread-how-to-clean-database)
how to clean database? - fsociety - 09-07-2020
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?
RE: how to clean database? - Pikami - 09-07-2020
(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.
RE: how to clean database? - Oni - 09-08-2020
(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.
RE: how to clean database? - fsociety - 09-08-2020
(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)Oni 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 ?
RE: how to clean database? - Mr.Kurd - 09-08-2020
What is your database in? The type and Size.
It would take 30 less than 30 mimutes to make an exporter in Java 🙋♂️