Parse a database??

[Essaye 12]

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 9]

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 12]

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 9]

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 3]

I can help with a regex @Essaye

[Essaye 12]

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 :'( :pepe: