The best process for filtering out any CSV File is using excel but sometimes the CSV file itself is very complicated and big that using excel becomes tough. CSV Filter is a free application which can filter any CSV file into new with your filter criteria like Containing, unique values etc.
So you can create lot of CSV files based on your filter criteria without touching your original file. You can also change separator from comma to something else if needed. Download CSV Filters
Related : Spilt large CSV files into smaller files with CSV Splitter