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

[#1]

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

[#2 · Accepted solution]

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

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