Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the text ABC.
I want to know if ABC is in the following String: DEF, CBX, ABC, RST, DPF.
Do you know how could I do that in a Text Object?
Thank you!
May be this:
=If(SubStringCount(YourString, 'ABC') >= 1, 1)
=Mid('DEF, CBX, ABC, RST, DPF',Index('DEF, CBX, ABC, RST, DPF','ABC'),3)