Clean Up & Parse Flat File for Database

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.