Case sensitivity

[Jase]

Hi,

I am trying to pick out all case varients of the word DaaS (i.e. DAAS, DaAs) from a text string. So far I have 

=count({<TITLE={"*DaaS*"}>} TITLE)

but this only returns those fields that match the case sensitivity exactly.

I have been searching for a solution but everything I see refers to changing the case at the point of loading the data. This is not an option.

Thanks in advance

Jason

[jwjackso]

The WildMatch function is case insensitive.

=Sum(If(WildMatch(TITLE,'*DAAS*') > 0,1,0))