Sidebar

Removing double quotes from CSV

0 votes
495 views
asked May 10, 2018 by chris-c-9050 (200 points)
I'm using a db query source node that has a header row and would like to remove the double quotes that surround each node in the message.  I've tried a number of things but I always wind up with one of two things.

1.  I'm able to remove all the quotes except the ones that begin and end each row

2.  I'm able to remove all the quotes, but I end up with a header row for each result in the file.

1 Answer

+1 vote

This was the answer...

var currentMessage = message.getNode('/');
message = qie.createCSVMessage(false, '"', ',', 'UTF-8', true);
message.setNode('/', currentMessage);

answered May 10, 2018 by chris-c-9050 (200 points)
...