Yes that is corrrect the last row has only one column that is the rowcount. So do you think my rowcount approach will work.

The file structure has 10 columns they are comma delimited but the last row has only one number hence the schema differs between all valid rows and the last row....

I cannot tell which one is the last record as it varies by file and every month. So once of the challenges is to identify the last record.