Hello, I am new to the forum. I'm Wesley, 38 years old and have been working on home automation for a while now. Recently I did an integration with node-red and the PLC. Everything is working well. Now in Belgium the energy prices are rising enormously, there will be a capacity tariff. This means …

[image] Steve-Mcl: const filtered = msg.payload.filter(e => (!!e && e.payload != null)) const converted = filtered.map(el => Number((el.payload + "").replace(",","."))) msg.payload = converted; return msg; EDIT: updated ↑ function to handle situation when payload is already a number Here is …

Hello Wesley, your msg.payload is an array so in order to pick one element of that array and convert its nested payload to a number you have to do .. for example : msg.payload = Number(msg.payload[1].payload) the above is for converting the string of element in position 1 if you want to convert…

Your variable is in msg.payload[1]. payload There’s a great page in the docs 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 propert…

[image] UnborN: if you want to convert all your strings then : msg.payload = msg.payload.map(el => Number(el.payload)) (Off the top of my head)... I suspect the value will need to have the comma changed to a decimal point msg.payload = msg.payload.map(el => Number(el.payload.replace(",",".…

opps .. missed that part .. you are right

Hello, Thanks in advance for helping me think. If I use msg.payload = msg.payload.map(el => Number(el.payload)) then [image] do i use the "replace" then TypeError: Cannot read property 'replace' of undefined I collect the data as follows: [image] Thanks

[image] Steve-Mcl: msg.payload = msg.payload.map(el => Number(el.payload.replace(",","."))) after Steve's post, I adjusted the payload [image]

one of your values will be invalid. Proof [image] when the payload contains [ { payload: '1,2' }, { payload: '3,4' }, { payload: null } ] you get error Cannot read property 'replace' of null You could filter the array first const filtered = msg.payload.filter(e => (!!e && e.payload != null)) co…

If I retrieve everything without trying to convert I have the values below: [image] I may be wrong (don't have much node red experience yet) but I don't think I have any invalid values? if i filter the array: [image]

You have changed the data format. The code we offered won't work now. Change code to... const filtered = msg.payload.filter(e => e != null) const converted = filtered.map(el => Number((el + "").replace(",","."))) msg.payload = converted; return msg;

[image] Steve-Mcl: const filtered = msg.payload.filter(e => e != null) const converted = filtered.map(el => Number((el + "").replace(",","."))) msg.payload = converted; return msg; [image] No succes :frowning:

Node-RED

Node-RED Forum

Convert string in array to value

General

WeSleY 18 January 2022 11:50 7

after Steve's post, I adjusted the payload

Topic		Replies	Views
Convert string value to something to work with General	14	923	11 August 2022
String to number with decimals (but without separator) General	22	1189	8 June 2022
Array Split trouble General	8	451	3 January 2022
Read a number in an array General	3	374	7 December 2022
Convert string to number General	6	1825	14 November 2024

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 string in array to value

Related topics