The files are CSV-adjacent, I should say. The issue here isn't the delimiter in fact, it's the fact that the format differs slightly between files, even within the same project. That, and the mismatch with the SQL DB format I want.
After rereading the post I realize that the op was talking about the schema of the files rather than the adhoc nature of trying to decode escape characters.
