I have a [Serial Number] field which can appear like the following : 000000000000002216
I want to make it 2216 but the amount of zero characters (from the left) can vary from one Serial Number to another.
So, I would like to find a way to retrieve the index of the first non zero character so that I will be able to use the Mid function.
I already tried : Mid ([Serial Number] , '<>0') but it didn't work.
Thank you (:
Be careful with one of the "capacity limits" of QlikView.. "Numbers" with more than 14 (or is it 15) digits will not be treated as numbers but will remain text-only.
I think we don't really need to add the Num function, unless you really want to add it. I think * 1 convert the text into a number and will get rid of 0s at the start. But Peter mentioned something interesting and I am not sure if that impacts the multiplication with 1. Waiting for his response to come through