I am trying to load a text file that has financial figures, but the file has a problem as it comes with scientific notation and of course when loading it with the File Reader Node the column type is forced into string due to the records that have the scientific notation.
See the text file
See the File Reader Node
When I try to convert the columns into numbers using the String to Number node the records or columns are converted into null
I know that is a data problem since it’s origin, but I wonder if there is a way to aproximate such numbers into double.
The String to Number node expects a single format for the decimal separator. You can’t have mixed decimal separators present.
In your original screenshot you only showed numbers with commas as the decimal separator. Now it turns out you also have numbers with a decimal point? If you had mentioned this in your first post it might have saved some time.
You’ll need to standardize your formats before the String to Number conversoin. I have no idea what your data looks like or how it’s arranged, but maybe explore using a String Manipulation node to make all your decimal separators match.