Data type Conversion

Hi all, I am working for a file where the input file has generic numeric values ex - 1E+13 , 1.00017E+13. I want these numbers to be in correct data format, I am using string and Int64 even double datatype but the numbers are not correct. The output numbers are different with many 0's. Kindly guide me through the steps to perform the task. The numbers are ID's and are having more than 15 digits. Kindly help

Email

Developer

Input

Help

Download

Accepted answers

@Kaish
convert the data type to double
this will be solved

mark done if solved.

Yoshiro_Fujimori

Hi I tried to recreate the issue, but couldn't.

Everythiing looks fine.

Please let me know if I miss anything.

Input

Workflow

Output (at Output Data Tool)

Output (at Excel)

All comments

@Kaish are you able to share some sample data?

@Kaish
convert the data type to double
this will be solved

mark done if solved.

Hi @tim-regas , Sure sharing few examples

1.00E+13

1.00E+13

1.00E+13

Not working, the data is getting in 0's, like 100000000000. 12000000000000000

@Kaish how do you expect your output?

@Kaish please add sample file instead of typing it.
will be in better position to help.

Hi @Raj I will provide the sample, I am currently working for my org. I will send you the file once I am working on my personal system.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703