AnsweredAssumed Answered

CSV Collector tab seperator

Question asked by Frank Koster on Jul 16, 2018
Latest reply on Jul 16, 2018 by Pradeep Kadambar

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.

Attachments

Outcomes