Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
apthansh
Creator
Creator

Number format

I have the below formatted cell..I want to extract numbers after the first 8 digits.I tried the below expression but it is eliminating 0's at the end and also there are some that are getting eliminated in the middle.

mid(Num(Replace(key, ',', '.'), '(dec)'),9) - Output is 1800010

apthansh_0-1598970271782.png

Is there any other work around for this please ?

Thank you much.

 

Labels (6)
3 Replies
Kushal_Chawda

try converting it first to text and then extract the string

mid(text(Replace(key, ',', '.')),9) 

or

mid(text(Num(Replace(key, ',', '.'), '(dec)')),9)

 

apthansh
Creator
Creator
Author

Thank you Khush - I tried this, but no luck..output is same as above.

apthansh
Creator
Creator
Author

I have attached the sample file, if that helps.Thank you much.