String with scientific notation to Number

Hi team,

I have a trouble with a CSV file where there are financial values (with scientific notation) in string format that I need to convert to number:

image

I would be thankful if you know any option to do that.

Current: 1,21067E+11 (String)
Expected: 121067000000 (Number)

Change the comma to a period as shown below. Then feed the results to the String to Number node which will produce a double.

Here’s a simple example for both single and multiple columns.
Scientific Notation to Double.knwf (27.4 KB)

Hello @rfeigel,

you don’t have to change comma to period prior to String to Number node as you can configure it to take comma as decimal separator.

Br,
Ivan

1 Like