Convert text to integer

[jmialoundama]

Hi, 

I have this column in text format and I would like to convert it to numeric format.

However I wonder if the '-' will be accepted in numeric format

thank you in advance

[sunny_talwar]

It would be challenging because some of the data points are greater than 14 digits long. Qlik is unable to read a number more than 14 digits as a number

Problem with big numbers (more than 14 digits)

[Vegar]

You wont be able to evaluate the number containing _ in your qlik application, but you should be able to do a workaround creating a dual. 

Take a look at the script below.

LOAD
   DUAL(Text, Num) as ICA_ORDER_Multi_niveau
;
LOAD
   Text,
   evaluate(PurgeChar(Text, '_')) as Num
inline [
Text
0001_1077_1324_1214_654000_
0002_2077_2436_1332_
];