Goodmorning,
i have a question. I try to find some products in a database which contain whole grain but not flower. All fine in this simple formula. But in some case products also contain sunflower oil. These articles should come out as yes. Is it possible to exclude sunflower and how. By a replace command? Is it possible in this formula or do i need to build a small flow with a find and replace tool? thanks for the help. best regards Barry
if Contains([Ingredients], 'Whole grain') and !Contains([Ingredients], 'flower') then "YES"
Else "NO"
ENDIF
