Parsing a DAT file into SQL database

I'm trying to parse a large data file into our sql database.  I have found the import csv to database smart service which would work with the "|" delimiter of the dat file except it has metadata as its first and last lines (not a csv header).  I have uploaded the file into an appian document object, but I can't figure out how to remove those lines so it works with the smart service.

I should also note the dat file is coming from an external datasouce and cannot be altered prior to ingestion.