String to number problem

General
1

Hello
I am scarping data from a web and I need to change from string to number. If I try to use this:
msg.payload = Number(msg.payload);
return msg
It doesn´t work for me as in Spain we use "," as "."
The fisrt debug is the data I want to change to number and the second one is what I get.
Screenshot_1
If the value is 0 it works fine.
Any idea how can I do it?

(PD: Sorry for my english :slight_smile: )

2

a quick google search finds this How to change commas into dots with JavaScript

1 Like
3

hi @Rufus,
Are you using function node?
try trim() values befor number().

if you are using change node, try it

if you know the maximum length of each array element that you realy want, you could test element length and exclude element [0] and [1] (for exemple) from your array. it will result in a new array that you can really convert to number.

4

Thanks for the quick response guys
I tried @zenofmud solution and it worked, thank you.
Screenshot_2

Next time I´ll try simple google seaches :slight_smile:

5

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.