Split the string into separate values

ukmoose · 7 September 2018 07:27

You didn't paste it in between ``` please EDIT your last post to correct this.

ukmoose · 7 September 2018 07:38

OK try this to get the idea...

flow surrounded by ``` so that you can import it...

[{"id":"7ec7ffcd.3ac498","type":"inject","z":"9a50778a.ed93a","name":"PIR1-OFF","topic":"","payload":"0","payloadType":"num","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":132.5,"y":165,"wires":[["84a1dbfa.6173a8"]]},{"id":"56c07777.086f9","type":"inject","z":"9a50778a.ed93a","name":"PIR1-ON","topic":"","payload":"1","payloadType":"num","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":132,"y":209,"wires":[["84a1dbfa.6173a8"]]},{"id":"81635019.8a1f28","type":"inject","z":"9a50778a.ed93a","name":"PIR2-OFF","topic":"","payload":"0","payloadType":"num","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":127,"y":304,"wires":[["29430074.7cd92"]]},{"id":"729cd490.f7fdd4","type":"inject","z":"9a50778a.ed93a","name":"PIR2-ON","topic":"","payload":"1","payloadType":"num","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":126.5,"y":348,"wires":[["29430074.7cd92"]]},{"id":"84a1dbfa.6173a8","type":"change","z":"9a50778a.ed93a","name":"","rules":[{"t":"set","p":"PIR1","pt":"flow","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":306.5,"y":185,"wires":[["d0b0375.0457c48"]]},{"id":"29430074.7cd92","type":"change","z":"9a50778a.ed93a","name":"","rules":[{"t":"set","p":"PIR2","pt":"flow","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":302,"y":323,"wires":[["d0b0375.0457c48"]]},{"id":"d0b0375.0457c48","type":"switch","z":"9a50778a.ed93a","name":"PIR1 STATE","property":"PIR1","propertyType":"flow","rules":[{"t":"eq","v":"0","vt":"num"},{"t":"eq","v":"1","vt":"num"}],"checkall":"true","repair":false,"outputs":2,"x":538.5,"y":240,"wires":[["936b1670.26f43"],["ad2a52e6.e304a8"]]},{"id":"936b1670.26f43","type":"switch","z":"9a50778a.ed93a","name":"PIR2 STATE","property":"PIR2","propertyType":"flow","rules":[{"t":"eq","v":"0","vt":"num"},{"t":"eq","v":"1","vt":"num"}],"checkall":"true","repair":false,"outputs":2,"x":721.5,"y":172,"wires":[["4c64d149.5070a8"],["5cbd381e.f58b2"]]},{"id":"ad2a52e6.e304a8","type":"switch","z":"9a50778a.ed93a","name":"PIR2 STATE","property":"PIR2","propertyType":"flow","rules":[{"t":"eq","v":"0","vt":"num"},{"t":"eq","v":"1","vt":"num"}],"checkall":"true","repair":false,"outputs":2,"x":723,"y":276,"wires":[["bc642787.6d91f8"],["abf9401b.bbf108"]]},{"id":"4c64d149.5070a8","type":"debug","z":"9a50778a.ed93a","name":"PIR1 OFF PIR2 OFF","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","x":960.5,"y":83,"wires":[]},{"id":"bc642787.6d91f8","type":"debug","z":"9a50778a.ed93a","name":"PIR1 ON PIR2 OFF","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","x":953,"y":235,"wires":[]},{"id":"5cbd381e.f58b2","type":"debug","z":"9a50778a.ed93a","name":"PIR1 OFF PIR2 ON","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","x":960,"y":153,"wires":[]},{"id":"abf9401b.bbf108","type":"debug","z":"9a50778a.ed93a","name":"PIR1 ON PIR2 ON","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","x":952,"y":293,"wires":[]}]

Flow requires both a PIR1 and PIR2 input before it starts...
There are many ways to do this but hopefully this way will help you understand what you need to do...

Srijan · 7 September 2018 08:19

sorry there is some problem with my keyboard

Srijan · 7 September 2018 08:27

Srijan · 7 September 2018 08:28

take a look at my flow.

zenofmud · 7 September 2018 09:48

Attach a debug node to each of the outputs of the function node and see what shows up.

Srijan · 7 September 2018 09:54

value of ldr, pir, temp,humidity

ukmoose · 7 September 2018 11:19

OK so you are sending temp AND PIR to the PIR(1,0) node.

But you only check to see if msg.payload is 1 or 0 i.e. PIR on or OFF.
If msg.payload is 1 you then check to see if msg.payload is either LESS THAN 0 or between 10 & 50. But the switch only passes on values of 1, which isn't one of the options.

My suggestion would be to store the PIR value as a flow variable ( see my earlier flow example uses a Change node to set flow.PIR to msg.payload) and then from the temp output from your function have a Switch node that checks on the status of flow.PIR

Kr4ntz · 31 January 2019 05:14

The world needs more people like you, mate.

eddy23 · 27 June 2020 08:47

hotNipi:

[{"id":"df6d6c66.b6c4e","type":"split","z":"d9f8d1d.5cd143","name":"","splt":",","spltType":"str","arraySplt":1,"arraySpltType":"len","stream":false,"addname":"","x":410,"y":820,"wires":[["fe502aa1.ee37c8","3ba2aff1.e8af5"]]},{"id":"d9822859.20a7b8","type":"inject","z":"d9f8d1d.5cd143","name":"","topic":"","payload":"15.4,50,23.8,79","payloadType":"str","repeat":"","crontab":"","once":true,"onceDelay":"","x":220,"y":820,"wires":[["bc23045.f5103f8","df6d6c66.b6c4e"]]},{"id":"2f990562.44d8ea","type":"debug","z":"d9f8d1d.5cd143","name":"out 1","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","x":930,"y":760,"wires":},{"id":"fe502aa1.ee37c8","type":"change","z":"d9f8d1d.5cd143","name":"to number","rules":[{"t":"set","p":"payload","pt":"msg","to":"$number(msg.payload)\t","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":580,"y":820,"wires":[["9052efa8.e5f0a","d6f23ad6.490eb8"]]},{"id":"9052efa8.e5f0a","type":"switch","z":"d9f8d1d.5cd143","name":"route","property":"parts.index","propertyType":"msg","rules":[{"t":"eq","v":"0","vt":"num"},{"t":"eq","v":"1","vt":"str"},{"t":"eq","v":"2","vt":"str"},{"t":"eq","v":"3","vt":"str"}],"checkall":"true","repair":false,"outputs":4,"x":750,"y":820,"wires":[["2f990562.44d8ea"],["35825546.228baa"],["d5e60d8b.47391"],["d97cb86c.da9478"]]},{"id":"35825546.228baa","type":"debug","z":"d9f8d1d.5cd143","name":"out 2","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","x":930,"y":800,"wires":},{"id":"d5e60d8b.47391","type":"debug","z":"d9f8d1d.5cd143","name":"out 3","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","x":930,"y":840,"wires":},{"id":"d97cb86c.da9478","type":"debug","z":"d9f8d1d.5cd143","name":"out 4","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","x":930,"y":880,"wires":},{"id":"2f3bddd7.cf80e2","type":"comment","z":"d9f8d1d.5cd143","name":"split","info":"Split comma separated string into separated messages.\nValue placed to msg.payload\nValue type will be still string.\n\nThere will be 4 messages out of this split node\n\nFor each msg also given a property "parts". \nIt will be used later on.","x":410,"y":760,"wires":},{"id":"d4a6401f.81de4","type":"comment","z":"d9f8d1d.5cd143","name":"convert","info":"Convert the value of msg.payload to the number using JSONata expression.\n","x":590,"y":760,"wires":},{"id":"60cbfa64.9cb4b4","type":"comment","z":"d9f8d1d.5cd143","name":"route","info":"Route every message to differet output by using switch node.\nAs property "parts" has been given to each message, we can use its \n"index" property to find out proper output\n\n","x":750,"y":760,"wires":},{"id":"bc23045.f5103f8","type":"debug","z":"d9f8d1d.5cd143","name":"source data","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","x":410,"y":980,"wires":},{"id":"3ba2aff1.e8af5","type":"debug","z":"d9f8d1d.5cd143","name":"spltted","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","x":530,"y":940,"wires":},{"id":"d6f23ad6.490eb8","type":"debug","z":"d9f8d1d.5cd143","name":"converted","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","x":660,"y":900,"wires":}]

This really helped me a lot thank you

nmwakde · 29 July 2020 11:21

hi Srijan,
I am facing the same problem.
can you help me to split a string into 4 real separate values?
i am trying to write the function code but not getting the result.

zenofmud · 29 July 2020 12:07

Here is one way to do it. Use a change node to remove the [ ] with two replaces of nothing, then use a jsaoata expression - $split(payload,',') - to 'split' the remainder into an array
Screen Shot 2020-07-29 at 8.06.16 AM

[{"id":"846aa32f.9c4a4","type":"change","z":"196c2b5b.d805c5","name":"","rules":[{"t":"change","p":"payload","pt":"msg","from":"[","fromt":"str","to":"","tot":"str"},{"t":"change","p":"payload","pt":"msg","from":"]","fromt":"str","to":"","tot":"str"},{"t":"set","p":"payload","pt":"msg","to":"$split(payload,',')","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":420,"y":360,"wires":[["df4e419b.5e2c4"]]}]

dceejay · 29 July 2020 12:53

or just feed it into a json node which will output the array...
and then maybe into a split node to send 4 values... if needed.

zenofmud · 29 July 2020 13:49

Much better than my idea!!

Orchitis · 17 December 2020 22:50

Thanks so much for posting the example flow. It helps us beginners tremendously and makes learning Node Red a little easier.

Rob1 · 13 April 2022 21:47

Schermafbeelding 2022-04-13 om 23.42.09

Hi, I read the things above but can't seem to get the values of t1 and t2 to put in a graph.

I got this far:
var output = msg.payload.split(",");

var t1 = parseInt(output[0]);
var t2 = parseInt(output[1]);
var p = parseFloat(output[2]);
var msg0 = {payload:t1};
var msg1 = {payload:t2};
var msg2 = {payload:p};
return [msg0 , msg1 , msg2];

But I guess I get NaN because msg0 is: t1:20.26 But I just want the number/value.

shrickus · 14 April 2022 04:53

Correct, you would need to remove everything up to the : before you try to use parseInt function. Try splitting again on the colon, to separate the key from the value, like this:

var output = msg.payload.split(",");
var [k1, v1] = split(output[0], ':');
var t1 = parseInt(v1);

I like to use a change node with a JSONata expression that uses a regular expression to find all of the key:val pairs, and reassemble them into a single object:

Here is the expression I used:

payload.$match(/([^:]*):([-.\d]+)[,\n]?/).[groups] {
    $[0]: $number($[1])
}

The nice thing about having all the keys and values is a single msg object is that you can pass the same data around to multiple ui nodes, and each one can choose which value to display by specifying the field name.

But I know that's pretty advanced syntax, and most people don't like it because it may be hard for someone else to maintain that code in the future. If you prefer to use a Javascript function, you may be able to get away with evaluating that string wrapped in curly braces, like so:

eval("msg.payload = {" + str + "}");
return msg;

But that is usually not good practice -- it relies too heavily on the format of the data string to be valid JS object syntax.

Rob1 · 14 April 2022 20:34

Hi shrickus, Thanks for the help I'm going to try the first part of your reply, that's already difficult enough for me :-). I know almost nothing about coding that's why I like Node red.

Schermafbeelding 2022-04-14 om 22.47.23

I did this:
var output = msg.payload.split(",");
var [k1, v1] = split(output[0], ':');
var t1 = parseInt(output[0]);
var t2 = parseInt(output[1]);
var p = parseFloat(output[2]);
var msg0 = {payload:t1};
var msg1 = {payload:t2};
var msg2 = {payload:p};
return [msg0 , msg1 , msg2];

But got the above error. Like I said I'm a Noob in coding. Do not Know what k1 and v1 does?

E1cid · 14 April 2022 21:08

Try

msg = msg.payload.split(":").slice(1,4).map(e => {
    return {payload:parseFloat(e)}
});
return msg;

Rob1 · 17 April 2022 06:32

E1cid, Thanks.

var output = msg.payload.split(",").slice(1,4).map(e => {
return {payload:parseFloat(e)}
});

var t1 = parseInt(output[0]);
var t2 = parseInt(output[1]);
var p = parseFloat(output[2]);
var msg0 = {payload:t1};
var msg1 = {payload:t2};
var msg2 = {payload:p};
return [msg0 , msg1 , msg2];

Schermafbeelding 2022-04-17 om 08.20.39

Topic		Replies	Views
Split a string into separate values General	4	2091	30 May 2020
Split String into different values General	5	215	20 July 2021
Splitting string into different values General	4	6157	4 December 2020
Get string from serial port and convert to separate key General	6	614	9 March 2022
Split string into objects General	4	668	21 February 2019

Split the string into separate values

Related Topics