Integer field after extraction from MySQL DB shows E+ exponential value, HOW-to fix?

[#1]

Hi folks,

Please have a look at the image below:

After trying to to extract a table from MySQL db, one of the data fields got corrupted. Its an ID field, tried several methods to fix it but failed to solve the issue --> Num(), floor(), int() functions where used. Please advise. Thanks in advance.

Best Regards,

R

[Colin-Albert]

Have a look at this thread

number of 17 digits

[#3]

Thanks Colin.

Regards,

R

[jagan · Accepted solution]

Hi,

If you are not using for calculation then try

LOAD

Text(Number) AS Number_Text,

*

FROM Datasource;

Regards,

Jagan.

[#5]

Thanks Jagan.

Warm Regards,

R

[jagan]

Hi,

Can you close this discussion.

Regards,

Jagan.