topic Re: Findoneof in QlikView

Findoneof

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

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

Re: Findoneof

sunny_talwar — Mon, 02 May 2016 16:50:27 GMT

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

1) QlikVieW & Other Ramblings‌

2) FindOneOf ‒ QlikView

Re: Findoneof

trdandamudi — Mon, 02 May 2016 16:51:59 GMT

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'.

Re: Findoneof

MarcoWedel — Mon, 02 May 2016 21:52:51 GMT

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

Re: Findoneof

Saravanan_Desingh — Mon, 02 May 2016 23:22:45 GMT

One of the best example is from marcowedel‌

Please check it here:

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

Re: Findoneof

qlikview979 — Tue, 03 May 2016 04:51:46 GMT

Thanks for every one