If Contains not working properly

Hi,

I am having issues with the "contains" function not picking up words. I have no doubt it's a simple mistake of mine but I can't pinpoint it.

In the attached sample dataset, I am trying to identify all line items with the words "fire extinguisher" however they don't seem to be getting picked up.

370 are being picked up, but 1224 are not. Can anyone suggest what I'm doing wrong here?

Thank you!

Contains issue.yxmd

test.xlsx

Datasets

Data Investigation

Accepted answers

Qiu

@bwat2435
The space between Fire Extinguisher of your formula is something wrong.
Reinputing it fixed the issue.

Contains issue.yxmd

All comments

mceleavey

Hi @bwat2435 ,

that was a bit of a strange one. It looks as though the case of the string is causing a problem, even though it looks fine on screen. I added a "Data Cleansing" tool after the input, and modified the case on the "Asset Description" field to Title Case and that seems to have fixed the problem. Odd though.