Would anyone have a tip for how to make my CSV data look like the data that was sent via FTP to a node red FTP server instance?
This is my flow, note the curly braces in debug window that how my Excel spreadsheet looks too.
This is what the data looks like before being FTP'd up the node red FTP server:
And when I retrieve the data from node red ftp server it looks like this all garbled. It seems like somewhere two sets of time stamps and electric meter readings are getting combined in an unwanted fashion.
Function block in my flow that Steve helped me with previously:
msg.payload = msg.payload.toString();
return msg;
My CSV node in the flow:
The data is sent from a Windows machine for what its worth and Node Red is running on Ubuntu 20.04.
This is the file node:
Any tips greatly appreciated I assume I need to add in a function block somewhere with some JavaScript code. Any JavaScript tips greatly appreciated not a lot of Wisdom there yet.