Does String Exist in Target

[WayneLambert]

Formula to check whether a string meets a given convention. The formula answers the question, "does the string to test exist in the WithinText Column?"

=IF(ISERROR(SEARCH("*string to test*",[@[WithinText Column]],1)),"No","Yes")

• SEARCH gives position of character where the tested string begins
• The ISERROR function turns the numeric value of the SEARCH function it into a Boolean result
• The IF function assigns a chosen result based upon the ISERROR being either TRUE or FALSE ("No" or "Yes" in the example)