AnsweredAssumed Answered

CSV Collector tab seperator

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

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.

Pradeep Kadambar
Pradeep Kadambar Employee Jul 16, 2018 11:04 AM
Correct Answer

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.

See the reply in context

Attachments

No one else had this question

Outcomes