I need help taking a very large flat text file and parsing it into a usable format for research purposes. The file has 1.5MM records. Attached is a sample of some records. I want to filter out to approximately 50k records based on some criteria I'll provide. Format of CSV or Excel are fine. Unique fields I want to have:
Film Name
Film Year
Director
Country Release Date
Country of Release
Release Venue (in parentheses)
I want to isolate all the data that has a release venue in ().
## Deliverables
Note that the data is already Tab Delimited.