How to convert from Scientific Notation (E) to Numeric Value

I am trying to figure out how to change from scientific notation (E) to numeric value. I tried using the select tool and change it to fixed decimals. Also tried using the formula ToNumbers (RegExOut11) and is not working. Does anyone have an idea how can I change it? The file input is in CSV and its not very clean, I had to use regex to parse values.

thanks!

Regex

Accepted answers

Since the number is 17 digits long, you need to pick a datatype with an appropriate size. The options you have are:

Int64

Fixed Decimal 17.0

Fixed Decimal 18.0

Fixed Decimal 19.1

Fixed Decimal 20.2

etc.

Anything else and you'll get the error "Number does not fit in..."

All comments

Since the number is 17 digits long, you need to pick a datatype with an appropriate size. The options you have are:

Int64

Fixed Decimal 17.0

Fixed Decimal 18.0

Fixed Decimal 19.1

Fixed Decimal 20.2

etc.

Anything else and you'll get the error "Number does not fit in..."

I thought that solved my issue but actually didn't.

when I use Int64, it is just adding 0000.

For example before I upload the file the actual number for the first row is 012813004450753515 and not 1281300000000.

could it be related to the file input format change?

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15867

MarqueeCrew 13708

apathetichell 13703