Findoneof

[qlikview979]

Hi Experts,

what is Findoneof () ? How it will work? Explain with Example?

[sunny_talwar · Accepted solution]

Have you tried a google or community search? I would try to look for already existing resources

1) QlikVieW & Other Ramblings‌

2) FindOneOf ‒ QlikView

[trdandamudi]

Hope the below helps:

FindOneOf - script and chart function

FindOneOf() searches a string to find the position of the occurrence of any character from a set of provided characters. The position of the first occurrence of any character from the search set is returned unless a third argument (with a value greater than 1) is supplied. If no match is found, 0 is returned.

Syntax:

FindOneOf(text, char_set[, count])

Return data type: integer

Example	Result
FindOneOf( 'my example text string', 'et%s')	Returns '4'.
FindOneOf( 'my example text string', 'et%s', 3)	Returns '12'. Because the search is for any of the characters: e, t, % ors, and "t" is the third occurrence, and is in position 12.
FindOneOf( 'my example text string', '¤%&')	Returns '0'.

[MarcoWedel]

please don't create threads for questions that can be answered by reading the help file and close some of your many open threads instead.

thanks

regards

Marco

[Saravanan_Desingh]

One of the best example is from marcowedel‌

Please check it here:

Re: Re: Number of times in a row a character appears

[qlikview979]

Thanks for every one