Can this be done? "Contains" in WebI

[Former Member]

Not sure how to express this, just trying to figure out if this is something that can be done...

I have a list of items (example):

1. ShayIng

2. Shay Ingram

3. 03/17 Shay

4. Shay

In the example, I want to find where the records contain the word Shay, and count them... how can I do this... is it a way for me to count it... if this was true, I would expect my count to equal 4

[amitrathi239 · Accepted solution]

create similar variable to this.

Var=Sum(If(Match([Sample];"*Shay*")) Then 1 Else 0)

[Former Member · Accepted solution]

Okay... let me try

[Former Member · Accepted solution]

Thank you very much!!! Rockstar once again 🙂