Does Anaplan have a "contain" function for words?

katalay

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!!

bdeaton

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.