function('abcd', 'bc') = true

Tue, 02 Jun 2009 20:21:11 GMT

Hi All,

I'm looking for a function that would state (true/false or position) whether a full given substring is included in a string e.g.

1. function('abcd', 'bc') = true / 2

2. function('abcd', 'be') = false / 0

I tried "findoneof" but it searches any character of a substring in a string so that in the second case it results in '2' ('b' is in the 2nd position).

Is there such a function or how else could I solve it?

BR,

Przemek

function('abcd', 'bc') = true

Tue, 02 Jun 2009 20:42:14 GMT

Index('abcd', 'be') would give you the position..

SubStringCount('abcd', 'bc')>0 would give you true/false (-1/0)

topic function('abcd', 'bc') = true in QlikView

function('abcd', 'bc') = true

function('abcd', 'bc') = true