We are currently performing maintenance on Appian Community. As a result, discussions posts and replies are temporarily unavailable. We appreciate your patience.
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.
Discussion posts and replies are publicly visible