Find Text in String

[microwin88x]

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!

[sunny_talwar · Accepted solution]

May be this:

=If(SubStringCount(YourString, 'ABC') >= 1, 1)

[jpenuliar]

=Mid('DEF, CBX, ABC, RST, DPF',Index('DEF, CBX, ABC, RST, DPF','ABC'),3)