Discussion Board for collaboration on QlikView Scripting.
I'm trying to filter rows in a web file using findoneof() function and, when the searched character string is more than 1 character it fails.Could you please take a look at the attached example and see what's wrong with the script/data?
Go to Solution.
Have a look into index() function then.
Have a nice evening,
I tried with some more characters in the search string and it seems to work for me.
What is the search string you are trying to use?
On which version of QV are you (I am currently on a machine with QV10SR2)?
10SR3. I've changed the searched string to '-miasto'. See the results in the attached file.
In your attached sample, position 4 is selected.
In either of the possible values in field @1:n
there is one character out of m, i, a, s, t, o, - on position 4. Or are your looking for a different function?
I was sure that findoneof searches full string. If not, then I would need one which does.
Ok., got it - index() is what I'm looking for! Thanks, Stephan.