Search Text in a String

ymandre

Hello Community,

 

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.

 

Thank you,

Yogesh

KirillKuznetsov

FIND("Anaplan", string)

KirillKuznetsov

@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

Misbah

@ymandre 

 

For finding "FIND" & For Replacing "SUBSTITUTE"

 

 

Misbah