I have been using the CSV Crate to successfully read csv files generated by one of my banks. However, the csv file generated by Fidelity has extraneous lines at the beginning of the file and extraneous lines at the end. Some of these lines are blank. Some have text such as the date/time stamp and other miscellaneous text. The header is always on line 5 and there's a blank line after the last record.
What approach can I take to read only the valid part of the file into the CSV crate?