Sidebar

How do I remove the Header row from a CSV message?

0 votes
265 views
asked Jul 14, 2020 by brandon-w-8204 (33,270 points)
I need to remove the header row from CSV. How can this accomplished?

1 Answer

0 votes

Here is the code to remove the header row:

var currentMessage = message.getNode('/');
message = qie.createCSVMessage(true, '"', ',', null, false);
currentMessage = StringUtils.replace(currentMessage, '\r\n', '\n');
currentMessage = StringUtils.replace(currentMessage, '\r', '\n');
message.setNode('/', StringUtils.substringAfter(currentMessage, '\n'));

answered Jul 14, 2020 by brandon-w-8204 (33,270 points)
...