Until recently we only had csv file with comma or semicolon separators, but now we also got and tab separator.
For comma we use \x2C, for semicolon \x3B.
For tab i tried several codes but none work:
\t
\x9
\9
\x09
tab copied from notepad
jdbc:csv:////folder/?_CSV_Header=true;_CSV_Separator=\t;_CSV_Quoter=";fileExtension=csv;ignoreDirtyData=true;
When I test the query data, it can't find the headers.
ERROR: Could not get resource data!. Caused by java.sql.SQLException: Invalid column or variable: Product
I can't figure out why this won't work.
The problem has nothing to do with the conenction string. The problem lies in the encoding of your file. Instead of being ASCII it is UTF-16 encoded. Are you expecting non ASCII content in these files ?
I saved the contents of the files using ntoepad and it works fine.
ASCII version
UTF-16 version (uploaded)
See with the sender if they can fix the encoding of the file.