CONTAINS

CONTAINS(text1, text2, ignore_case)
Returns whether a string is contained inside another string.

text1The text string containing your substring.
text2The text string to look for.
ignore_case(Optional) Whether you want to ignore the case of the text.

REMARKS
* If "IgnoreCase" is left blank, then False is used.
* This function can include wildcards.

MORE EXAMPLES

 A
1=JS.CONTAINS("text", "sometext") = -1
2=JS.CONTAINS("TEXT", "sometext", TRUE) = 0
3=JS.CONTAINS("TEXT", "sometext", FALSE) = -1
4=JS.CONTAINS("one", "londoner") = -1

MORE FUNCTIONS
??


© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext