Does Anaplan have a "contain" function for words?

Occasional Contributor

Does Anaplan have a "contain" function for words?

Hi, 

 

I am trying to create a module (line item) from a list formatted as boolean. 

Does Anaplan have a built in contain function so that I can select the words that I want ?

 

i.e. if column 1 contains "SKY" then TRUE else FALSE

 

Thank you!!

Message 1 of 3
2 REPLIES 2
Certified Master Anaplanner

Re: Does Anaplan have a "contain" function for words?

What I think you want is the FIND function: https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/FIND.html. If the text is found, then it returns the character number where it starts otherwise it returns 0. You could set up a formula like FIND ("SKY", 'Column 1') > 0 to generate the TRUE/FALSE output if the item is found.

Message 2 of 3
Occasional Contributor

Re: Does Anaplan have a "contain" function for words?

Thank you one more time!!
Message 3 of 3