Hi Everyone, How can I parse a scientific numbers to general numbers format? [image]

You screenshot shows you have the Function code correct, but it doesn't show where the Function node is in the flow. All I can see is an Inject node connected to a Function node and nothing after that. It looks like it is that Function node you have put this code into. Does that mean you are inject…

Show us how you have configured the file node. On the debug is that last lines as I asked, or is there only one?

I thought you meant the function node connected to the debug node!

No, I said [image] Colin: Feed the file node into a debug node and show us what the last few lines look like. The data you are trying to interpret is coming out of the File node isn't it? What is the function node doing anyway? Perhaps I don't understand what you are trying to do. I thoug…

[image] Colin: what you are trying to do What I am trying to do is change the format of the data below i.e F1, 0.1002200000E+003 I want it to read as F1, 100.22 that is all. Can you save the following file and try it? !@rProfit_Value,@rPerformance1_Value,@rPerformance2_Value,@rPenalty_Valu…

So feed the output of the file node into a debug node and show us what you get.

Hi @Munier I think you've shown us the file contents enough times to see what you have got. I assume you want to replace all such numbers including those in the first few lines? If so, you can use the following Function node code: msg.payload = msg.payload.replace(/(-?\d+\.\d+E[-+]\d+)/g, funct…

[image] knolleary: msg.payload = msg.payload.replace(/(-?\d+.\d+E[-+]\d+)/g, function(v) { return Number(v) }) return msg; I have used the function node code you've suggested it gives the same scientific format for the numbers. I can post the bitmap if you like.

Can you confirm where you put the Function node? A screenshot of your flow may help.

Node-RED

Node-RED Forum

Parsing the scientific numbers to general numbers format

General

Munier 1 April 2020 11:53 11

Here is what I get

Topic		Replies	Views
String to number convert General http-request	6	1325	15 August 2022
String to number with decimals (but without separator) General	22	1188	8 June 2022
Change Node: string to number General	5	1318	22 September 2022
Sorting a string General	2	191	24 February 2023
String with 2 points from CSV to number General	6	192	23 March 2023

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.

Parsing the scientific numbers to general numbers format

Related topics