Skip to Content
0

Can this be done? "Contains" in WebI

Jun 19, 2017 at 06:28 PM

36

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
AMIT KUMAR
Jun 19, 2017 at 07:42 PM
1

create similar variable to this.

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Okay... let me try

0

Thank you very much!!! Rockstar once again :-)

1