Does Anaplan have a "contain" function for words?

Question

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 · Accepted Answer

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.

katalay · Accepted Answer

Thank you one more time!!