Here is the issue with the SPLIT NODE
You can look at before and after.
Nothing complicated, it is the data from my Solar PV invertor in CSV format
[{"id":"6e41fe50023f1d6a","type":"csv","z":"8a38b732ace992cf","name":"","sep":",","hdrin":"","hdrout":"none","multi":"one","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":310,"y":260,"wires":[["b20f131bce1b4ad4"]]},{"id":"b20f131bce1b4ad4","type":"split","z":"8a38b732ace992cf","name":"","splt":"\\n","spltType":"str","arraySplt":1,"arraySpltType":"len","stream":false,"addname":"","x":430,"y":260,"wires":[["cbc6f3e7152be3e2"]]},{"id":"cbc6f3e7152be3e2","type":"join","z":"8a38b732ace992cf","name":"","mode":"custom","build":"array","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"","count":"","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":550,"y":260,"wires":[["7805df97f8f25053"]]},{"id":"7805df97f8f25053","type":"debug","z":"8a38b732ace992cf","name":"BEFORE","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":680,"y":260,"wires":[]},{"id":"15bf372e29016f35","type":"inject","z":"8a38b732ace992cf","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"20240624,17:45,11530,2.882,500,360,0.090,NaN,NaN,NaN,233.2","payloadType":"str","x":170,"y":260,"wires":[["6e41fe50023f1d6a"]]},{"id":"fe04c0f14e699719","type":"csv","z":"8a38b732ace992cf","name":"","sep":",","hdrin":"","hdrout":"none","multi":"one","ret":"\\n","temp":"","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":310,"y":360,"wires":[["531ccdbc05a2d3d6"]]},{"id":"531ccdbc05a2d3d6","type":"split","z":"8a38b732ace992cf","name":"","splt":"\\n","spltType":"str","arraySplt":1,"arraySpltType":"len","stream":false,"addname":"index","x":430,"y":360,"wires":[["7bf394304d80cc24"]]},{"id":"7bf394304d80cc24","type":"join","z":"8a38b732ace992cf","name":"","mode":"auto","build":"array","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"","count":"","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":550,"y":360,"wires":[["37ae043f082b33d6"]]},{"id":"37ae043f082b33d6","type":"debug","z":"8a38b732ace992cf","name":"AFTER","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":680,"y":360,"wires":[]},{"id":"fde380b07543ff03","type":"inject","z":"8a38b732ace992cf","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"20240624,17:45,11530,2.882,500,360,0.090,NaN,NaN,NaN,233.2","payloadType":"str","x":170,"y":360,"wires":[["fe04c0f14e699719"]]},{"id":"bba193768810830b","type":"comment","z":"8a38b732ace992cf","name":"","info":"BEFORE UPDATE","x":380,"y":200,"wires":[]},{"id":"9657f7be06c33d42","type":"comment","z":"8a38b732ace992cf","name":"","info":"AFTER UPDATE","x":380,"y":420,"wires":[]}]
Here is my bad, I didn't need to use the split and join node anyway, so I should say thank you for making me re-evaluate what I am doing. As an retiree and 2 year veteran to Node-Red / Javascript, I am learning as I go and I am now on V4 of my solar panel output, where I have eliminated almost Ā½ my Nodes, which usefully feed my automations in HA.
My entire life has been built on my ethos - 'All good learning comes from ignorance and mistakes, but never, never give up'.
Keep at it my friends