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

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.