topic FindOneOf need explaination in QlikView

FindOneOf need explaination

Anonymous — Thu, 24 Nov 2011 07:40:24 GMT

Hi,

findoneof( 'my example text string', 'et%s') returns '4'

findoneof( 'my example text string', 'et%s', 3) returns '12'

findoneof( 'my example text string', '¤%&') returns '0'

I am abot to understand when we want to know the n;position of particular character it returns the number of position but what 'et%s','et%s', 3, and '¤%&' signifies here.

Please explain.

best regards

Shubham

FindOneOf need explaination

SunilChauhan — Thu, 24 Nov 2011 07:47:26 GMT

findoneof( 'my example text string', 'et%s') returns '4' shows the position 1st occurence of any one from e and t

findoneof( 'my example text string', 'et%s', 3) returns '12' shows the position 3 rd occurence of any one from e and t

findoneof( 'my example text string', '¤%&') returns '0' show there is no match for string hence it is 0

hope this help

FindOneOf need explaination

Anonymous — Thu, 24 Nov 2011 07:54:40 GMT

Thanks for your reply Sunil, but I didn't understand that what do you mean by from the position 1st occurence of any one e and t. Does it search from the e and t an then how come it is returning 4 for above example. what the the search character here??

Regards,

Shubham

FindOneOf need explaination

SunilChauhan — Thu, 24 Nov 2011 08:57:57 GMT

position means first character is at first position ,2nd character is at positition2. an so on.

position 12 3 4

findoneof( 'my example text string', 'et%s') returns '4'

shows the position 1st occurence of any one from e and t

e at postion 4

1st occurence meancy first time appearing if t comes first then also we will search position of t

4 10 12

findoneof( 'my example text string', 'et%s', 3) here 3 means 3rd occurence

e is at firsst occurence means postion 4 theen again e is at 10 th position i.e 2nd occurence and finally t is at 12 position which is 3rd occuence

i.e final answer is 12

hope this helps

FindOneOf need explaination

Anonymous — Thu, 24 Nov 2011 09:47:44 GMT

Thank you Sunil.

Re: FindOneOf need explaination

Wed, 21 Jan 2015 10:20:07 GMT

need to improve your english. sorry for that advice.

Re: FindOneOf need explaination

Mon, 24 Aug 2015 06:06:52 GMT

can anybody explain me what is the use of %s.