How to write a script for a clean mail database?

Question

Python

Hello user. Little time and no experience in this, although as elsewhere. There is a file base_email.txt and in it all sorts of quotes dots and ip. Task: remove all the nonsense so that only mail remains
From:

["[email protected]","active","available","2015-02-12 14:14:54","00.000.00.000","","0.0.0.0","1111114","2014-05-12 18:00:00","","","","","","0.0.0.0","","","","","Pavel","Durov",""]
["[email protected]","active","available","2015-02-12 14:14:54","00.000.00.000","","0.0.0.0","1111114","2014-05-12 18:00:00","","","","","","0.0.0.0","","","","","Thank","You",""]

AT

[email protected]
[email protected]

Answer 1

https://regex101.com/r/kG3zE4/1
regex that will select most valid soaps.
then a bit of Google on the subject of how to apply it in the tags indicated in the question, and everything will work out.

Answer 2

awk -F\" '{print $2}' base_email.txt