This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have a below requirement to be accomplished,
In a string I need to find the position of first numerical value from left.
From the above strings I need to get the output of 5,6,10 respectively, which are positions for the first numeric from left.
The above are the example strings and it could vary in any manner.
Could anyone please help me out on this?
Thanks & Regards,
Karthikeyan A R.
Load *, FindOneOf(Example, '1234567890') as Number
View solution in original post
Data: Load *, index(Example,left(keepchar(Example,0123456789),1)) as tmp1 inline [ Example asdf1234 asdf 1234 computer 23technology ];
=Index('computer 23technology',2) =Index('asdf 1234',1) =Index('asdf1234',1)
from the internal help I gather that you can pass several characters to look for to the INDEX() function? Then you could write like
>>> INDEX([field], '0123456789') <<<
and that should return the position of the first occurence of any of these, no?
Give it a try.
Thank you for your reply.
But the strings with numeric will be dynamic. We cannot exactly say whether the number is 1 or 2 or 3.
So first we need to find the first number in string from left and then its position.
I have tried the above but it is not working as I expected.
The below function works,
But not with this: Index('text0123','0123456789')