I need to store a value into CSV as “Value”, but when I add delimited quotations in a function node value, send through the csv node and store into a file, if I open the resulting file in Notepad I get “”“Value”"" but if I open in Excel it shows as “Value”.
I have tried a wide variety of ways, but with no success. I either get NO Quotations, or Triple Quotations. Single Quotations work, but are not suitable for this application (not my choice).
I have even tried:
var quotes = String.fromCharCode(34);
formattedTime = quotes + formattedTime + quotes;
Way to recreate:
From a function node
var formattedTime = "12-10-14 12:30:00";
formattedTime = "\"" + formattedTime + "\"";
Store the value in an array, send msg.payload through csv node and save to a file.
- [ ] Node-RED version: 0.18.7
- [ ] node.js version: 8.11.2
- [ ] npm version: 5.6.0
- [ ] Platform/OS: Ubuntu 18.04 LTS