Question on "contains" function

Hi all,

I have following text strings, and I would like to get all the ones contain "text" (case insensitive). I tried Filter with "Contains("text",[String]) but it did not show the correct results. Could someone help and let me know why ? Thank you

String

Text A

A

Text B

Text c

Txt C

text C

B

Output

String

Text A

Text B

Text c

text C

TWW

Transformation

Accepted answers

@tww
Did you include the 1 in your formula?

All comments

@tww
Did you include the 1 in your formula?

@tww Your Contains() function syntax is not correct it should be the other way around Contains([String],'text')

Thank you, @Qiu and @binu_acs .

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703