Search Text in a String

ymandre
Occasional Contributor

Search Text in a String

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

3 REPLIES 3
KirillKuznetsov
Certified Master Anaplanner

Re: Search Text in a String

FIND("Anaplan", string)
KirillKuznetsov
Certified Master Anaplanner

Re: Search Text in a String

@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
Moderator

Re: Search Text in a String

@ymandre 

 

For finding "FIND" & For Replacing "SUBSTITUTE"

 

 

Misbah