Icon

CSV Writer and reader nodes with several issues

Issue1. CSV WriterQuotes getting doubled up2. CSV ReaderWhile reading with column separator enclosingquotes getting removed even though quotes are setto be kept No issue here, just trying to determine the actual encoding of a file wihtout success. Possible feature request / suggestion to ensure file /data integrity? https://forum.knime.com/t/bug-csv-writer-and-reader-nodes-with-several-issues/44512 Copy presumably emptycolumn "Cleaned" andpaste into a text editorlike Knime Sample dataDefaultnode configureation| as delimiterMissingEscape Quotes| as delimiterBaseline to showexpected resultsCSV Strcuturebroken due to<0x00>Read withoutcolumn separatornor quote removalRemove charactersused in sample dataWithoutcolumn separatorFails uponvalue diffBaseline to showexpected resultsand keep quotesTOPValue diffshowing extraquotesKeep quotesto check fordoubled up quotesand withoutcolumn separatorTOPValue diffshowing extraquotesTOPValue diffshowing <0x00>when copy & pastedinto text editorCreate Temp Folder Table Creator CSV Writer CSV Writer CSV Reader CSV Reader Files/FoldersMeta Info List Files/Folders Path to URI File Reader Extract URI Info String Replacer CSV Reader Table DifferenceFinder CSV Reader Table DifferenceFinder CSV Reader Table DifferenceFinder Recreate table Recreate table Table DifferenceFinder Issue1. CSV WriterQuotes getting doubled up2. CSV ReaderWhile reading with column separator enclosingquotes getting removed even though quotes are setto be kept No issue here, just trying to determine the actual encoding of a file wihtout success. Possible feature request / suggestion to ensure file /data integrity? https://forum.knime.com/t/bug-csv-writer-and-reader-nodes-with-several-issues/44512 Copy presumably emptycolumn "Cleaned" andpaste into a text editorlike Knime Sample dataDefaultnode configureation| as delimiterMissingEscape Quotes| as delimiterBaseline to showexpected resultsCSV Strcuturebroken due to<0x00>Read withoutcolumn separatornor quote removalRemove charactersused in sample dataWithoutcolumn separatorFails uponvalue diffBaseline to showexpected resultsand keep quotesTOPValue diffshowing extraquotesKeep quotesto check fordoubled up quotesand withoutcolumn separatorTOPValue diffshowing extraquotesTOPValue diffshowing <0x00>when copy & pastedinto text editorCreate Temp Folder Table Creator CSV Writer CSV Writer CSV Reader CSV Reader Files/FoldersMeta Info List Files/Folders Path to URI File Reader Extract URI Info String Replacer CSV Reader Table DifferenceFinder CSV Reader Table DifferenceFinder CSV Reader Table DifferenceFinder Recreate table Recreate table Table DifferenceFinder

Nodes

Extensions

Links