malachydevlin

Count occurances of value in value list.

Discussion created by malachydevlin on May 8, 2015
Latest reply on May 9, 2015 by disabled_jackrodgers

Hi,

I have a value list (with file extension types)

e.g

 

pdf

doc

xls

 

I want to return if a search criteria (which will also be an exact filetype) exists at least 1 time in the value list.

I am using patterncount but it only works on the first item in the value list.

 

so really if I have the search strings:

doc then I want answer =1

 

thanks in advance.

Outcomes