Skip to Content
avatar image
Former Member

Can this be done? "Contains" in WebI

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 19, 2017 at 07:42 PM

    create similar variable to this.

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

    Add comment
    10|10000 characters needed characters exceeded