Data type Conversion

[Kaish]

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

[tim-regas]

@Kaish are you able to share some sample data?

[Raj · Accepted solution]

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

mark done if solved.

[Kaish]

Hi @tim-regas , Sure sharing few examples 

1.00E+13

1.00E+13

1.00E+13

[Kaish]

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

[tim-regas]

Hi @Kaish Is the data coming from an Excel sheet if so could you share a couple values in an Excel file? The sample data you shared when converted to a double would be 10000000000000.

[Raj]

@Kaish how do you expect your output?

[Raj]

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

[Kaish]

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.

[Raj]

@Kaish No worries.