Parse a database??

[Essaye]

Hello guys, i want to parse a database , because its mixed lines...

You see those lines mixed to others? : http://prntscr.com/npugyb

I want all those mixed lines, to be lines like that : http://prntscr.com/npufu7


I really appreciate if you find for me (you will get +3 rep because its very important data) . i already tryed to search on google but i find nothing..

 

[Sartux]

Hello guys, i want to parse a database , because its mixed lines...

like you see that : http://prntscr.com/npugyb

I want all those mixed lines, to be lines like that : http://prntscr.com/npufu7

A tricky one. The best way will be probably to construct a regex query to grab what you need.

This might help:
https://stackoverflow.com/questions/18144431/regex-to-split-a-csv

Alternatively you can just import it into excel, split the lines at the brackets and delete the lines you don't need.

 

[Essaye]

Hello guys, i want to parse a database , because its mixed lines...

like you see that : http://prntscr.com/npugyb

I want all those mixed lines, to be lines like that : http://prntscr.com/npufu7

A tricky one. The best way will be probably to construct a regex query to grab what you need.

This might help:
https://stackoverflow.com/questions/18144431/regex-to-split-a-csv

Alternatively you can just import it into excel, split the lines at the brackets and delete the lines you don't need.

Yes i tried with Excel but its very hard

---

And i dont know how to create a regex i never touch the programmation :c

 

[Sartux]

Yes i tried with Excel but its very hard

---

And i dont know how to create a regex i never touch the programmation :c

---

Well now is a good time to learn!
You can try this site which will help with creating regex: https://regexr.com/

Then you can follow the comments here which will let you regex a csv file using python: https://stackoverflow.com/questions/47016757/how-to-apply-regex-sub-to-a-csv-file-in-python

 

[DarkAng31]

I can help with a regex @Essaye

 

[Essaye]

Yes i tried with Excel but its very hard

---

And i dont know how to create a regex i never touch the programmation :c

---

Well now is a good time to learn!
You can try this site which will help with creating regex: https://regexr.com/

Then you can follow the comments here which will let you regex a csv file using python: https://stackoverflow.com/questions/47016757/how-to-apply-regex-sub-to-a-csv-file-in-python

---

i understand nothing :'( epe: