Hot to filter to a part of a "Value" 1

[rudiwenger]

How can I filter to A PART of the value?
Let’s say the field values are
“One Alpha”
“One Beta”
“Two Alpha”
“Two Gamma”
and I would like to find all values CONTAINING “One”

I know the Operator “InList” (see example below):
=If([Query1].[Field1] InList("One Alpha";”One Beta”;"okay”;”Not Okay”)
But in this case I’ve to enter the whole value

 

[blom0344]

Depending on the BO version there should be a 'match' function that returns a boolean. You can use this in conjunction with a wildcard..

Ties Blom

 

[rudiwenger]

Sorry I didn't expalin correctly:
In a Query, of course, you can use "Match" but on a variable in the Report of a "Wegintelligence" (BOXI Release2) Report Variable, seems that "Match" is NOT available. Isn't it?

 

[blom0344]

The reference to 'Match' was not for use in the query , but a typical BO 6.5 client function. I can imagine this not being available in WEBI. However, I imagine you can define a boolean expression in WEBI that uses a like operator on a string (like returning 1 for positive match and 0 for a negative outcome)?

Ties Blom

 

[rudiwenger]

Unfortunatly there is no "like" available.

The avilable Operators are: (in addituon to =, <> etc)

All And Between Block Body Bottom Break Col Distinct ForAll ForEach In IncludeEmpty InList Not Or Reort Row Section Self Top Where

 

[hilfy]

You could also use the Pos() function which returns the position of one string in another string. So you could do something like this:

Pos([Field1]; "One")

I know that the Pos() function is available in XI, but I haven't worked in any of the earlier versions so I don't know if it was available before XI.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.