3 ms·
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
by Rendello 1y ago
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.
- noosphr 1y agoWith the predefined ascii delimiters there is no difference between formats, because you can't choose anything but the dimiters ascii gives you.
- noosphr 1y agoAfter 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. Ascii delimiters will not save you there.