topic Re: How to search for wildcards in set-analysis? in App Development

How to search for wildcards in set-analysis?

Anonymous — Mon, 30 Jan 2017 14:48:42 GMT

Hi,

I have fields containing the value '?'.

Now I want to count those fields like:

count({1<[Field] = {'?'}>} [Field])

But this does not only apply to fields with '?', it interpretates the ? as a wildcard and sums up other fields like 'a' and 'b'.

The question is, how can I write the {'?'} expression, so that I get what I want?

thanks

sunny_talwar — Mon, 30 Jan 2017 14:54:02 GMT

Like this:

Count({1<[Field] = {'*?*'}>} [Field])

sunny_talwar — Mon, 30 Jan 2017 14:55:20 GMT

Or this:

Count({1<[Field] = {"=WildMatch(Field, '*?*')"}>} [Field])

Anonymous — Mon, 30 Jan 2017 15:00:23 GMT

Like this:

Count({1<[Field] = {'*?*'}>} [Field])

___

This version returns all of my fields as true

Anonymous — Mon, 30 Jan 2017 15:01:43 GMT

Or this:

Count({1<[Field] = {"=WildMatch(Field, '*?*')"}>} [Field])

___

This version returns none of my fields as true

Anonymous — Mon, 30 Jan 2017 15:03:41 GMT

Thanks for the fast answer, but both methods don't work as I need them to

sunny_talwar — Mon, 30 Jan 2017 15:10:01 GMT

How about this:

Count({1<[Field] = {"=WildMatch(Replace(Field, '?', '|'), '*|*')"}>} [Field])

marcus_sommer — Mon, 30 Jan 2017 15:26:57 GMT

Slightly different but with the same approach:

count({< [Field]= {"=[Field]<>purgechar([Field],'?')"}>} [Field])

- Marcus

Anonymous — Tue, 31 Jan 2017 07:12:01 GMT

Both of the last two answers work as I intended them to work - thanks for the help

The code is not quite as simple as one should assume though, but now one can look it up in this thread^^