Today I got a CSV file out of a platform, and I need to extract the values.
The problem is: three of the columns have space characters in their name.
Normally this is not a big problem: you could take a text editor and edit the first line of the file...
But in this case a couple of not-so-technical-customers have to do the export of the csv files (out of a website) and should be able to upload the files to the Node-RED instance via drag & drop.
Now after the csv import node there are the three objects like payload.read out
which I can't address inside the next function node - or do I?
Thereās a great page in the docs (Working with messages : Node-RED) that will explain how to use the debug panel to find the right path to any data item.
Pay particular attention to the part about the buttons that appear under your mouse pointer when you over hover a debug message property in the sidebar.
This path will show the correct format for properties with spaces or special characters
eg. payload["path with spaces"]
I think I forgot to try the easiest thing which was located right in front of my nose...
That's why I love to use Node-RED: because of people like you who are not getting tired of helping people like me, even if the solution is that easy and straight-forward like this one.