search

davidesner / keboola-ftp-extractor

Other
1 stars 0 forks source link

csv without enclosure #4

Open pocin opened 6 years ago

pocin commented 6 years ago

Hi David! Would it be possible to support csvs without enclosure? When the field is left blank it defaults to " so there is not really a way to not use one. We tried setting enclosure to some exotic unicode characters, but snowflake doesnt like that on import.

davidesner commented 6 years ago

Hi, this behaviour is on KBC side I believe. The extractor does not set "enclosure":"\"" when the field is left blank. It produces "enclosure":"" instead in the manifest file. See https://github.com/davidesner/keboola-ftp-extractor/blob/74f065246632914db0d5a6e34807237fea3f0eea/src/main/java/keboola/ftp/extractor/config/FtpMapping.java#L60

pocin commented 6 years ago

Ah that makes sense. I've made a zd ticket and will update it here for future reference if it's possible. Thanks!