Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
aambasht1626789554
Contributor
Contributor

convert string to number

I am trying to convert phone numbers stored as string to number in Tmap. I tried below. Both give number format exception. I checked that they work fine until the 9th digit but throw that exception starting 10th. What can i do to resolve this?

Integer.parseInt("8284670083")

Mathematical.INT("8284670083") 

Labels (3)
1 Reply
Senthil1
Contributor
Contributor

Integer value ranges from -2147483648 to +2147483647.. .

 

8284670083 - this value exceed this range. hence you are getting exception.