I am looking for a function to find a character(s) within a string, similar to CONTAINS function. For example, I need to find the word Ananplan in the string "I love Anaplan".
Is there a function for this? If yes it will be really helpful if you can share.
@ymandre check this anapedia article https://help.anaplan.com/b4571668-130a-4de8-a7b2-57439714f344
also i'd recommend to look at other text formulas and functiuons there
For finding "FIND" & For Replacing "SUBSTITUTE"