I feel this should be possible using basic nodes but I'm failing to acheive a result I've got and rgb triple coming in via MQTT as a csv string e.g 255,255,0 but I need to change it to an array to feed the WS2801 node

String method split() with separator comma split(",") makes array Or with split node [image]

That just seems to give me 3 separate string messages

[image] cymplecy: I've got and rgb triple coming in via MQTT as a csv string e.g 255,255,0 but I need to change it to an array to feed the WS2801 node Simon, Does this JSONata expression in a change node do what you want? payload.$split(",").$number() (not sure if you need an array of num…

Yes it does but I trying to see if a core node would do it - I felt the csv node would do it on its own but it doesn't

Well, of course the change and function nodes are core... but I get your point. So here is an alternative solution -- use the template node to build an array "string" and output as "parsed JSON" [image] ... which only works if you are guaranteed to have input strings of comma-separated numbers. …

yep _ I had that one but I think its pretty much the same as using JSONata Actually - your template looks different to mine #strange These are the setting I needed to get an array output [image]

Forgive me for digging up this topic. I have a csv file TF1,1 France 2,2 France 3,3 France 5,5 M6,6 ... I would like to convert it to an array: msg.payload: array[200] 0: "TF1","1" 1: "France 2","2" 2: "France 3","3" 3: "France 5","5" 4: "M6","6" ... I tried whith split - join…

Node-RED

Node-RED Forum

Convert csv string to array

General

Andrei 12 December 2019 22:03 4

Right, but can be fixed by using a join node after the split node, with below config.

a-1

Time parsing - how to cut up time messages

Topic		Replies	Views
Getting an array from col1 and col 2 out of a csv file General	2	580	14 October 2022
HELP Convert array of objects to array of arrays using change node General	8	345	8 November 2022
Help - CSV node issue General	25	1658	21 February 2020
Convert string value to something to work with General	13	927	12 June 2022
Help\| how to split string from mqtt General	40	2712	10 March 2022

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Convert csv string to array

Related topics