Convert csv string to array

General
1

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

2

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

3

That just seems to give me 3 separate string messages

4

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

a-1

1 Like
5

Simon, Does this JSONata expression in a change node do what you want?

payload.$split(",").$number()

(not sure if you need an array of numbers, or just leave them as strings...)

6

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

7

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
image1093Ă—571 27.3 KB

... which only works if you are guaranteed to have input strings of comma-separated numbers.
In practice, you would probably want to add some kind of error checking.

1 Like
8

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
image508Ă—648 79.3 KB

9

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 and template node whitout succes.
Can you help me
Thanks

10

Have you tried the CSV node?