How can I write data with double quotes " to a file using CSV Writer
123,test"data,dummy
I am trying to write the sample data to a file using CSV writer & i want all fields to be enclosed in quotes
“123”,“test"data”,“dummy”
The CSV writer node has options to always set quotes. Default is when needed.
4 Likes
I need CSV writer with quotes and the data can also contain quotes
“123”,“test"data”,“dummy”
but currently while writing csv writer is writing this as
“123”,“testdata”,“dummy”
Hello @amar.khavare,
then use option replace right quote in data with and add ". Problem you’ll have then is how to read it back into KNIME if needed. Also you can use CSV Writer (Labs) node which has option to Quote Escape Char which will work fine in combination with CSV Reader (Labs) in case you need to read data back into KNIME.
Br,
Ivan
1 Like
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.