Convert txt file to Excel

We were provided Tax delinquent data from our County in a txt file. The file contains 2 types of records (SCNDELQ and SCNINST)..example attached. The 2 types of records are layed out in different formats (attached).

We are trying to figure out if there is code, a Macro, or the best way to convert the SCNDELQ records into 1 Spreadsheet & the SCNINST records into a separate spreadsheet.

Would like to also separate the data in each record into Columns in the Spreadsheets. The txt file the County sent to us does not separate the data with commas or spaces (so having difficulty importing into Excel with separate columns). I've attached a pdf explaining the delimited data characters.

Any help from the community would be great! 🙂

Thank you!