Filter on part of text

[ingridmerx]

I want to filter a graphic in QV on just part of a column's text value. So not just the whole content of the record but a part of it. e.g. only select records that contain "example". This would give me all records with value: "This is an example". What is the right syntax? thank you

[prma7799]

Like this ?

=PurgeChar('This is an example' , 'This is an')

If you have another expected output so please share some sample data with us.

[ingridmerx]

No that is not what I ment. I want to filter records in a graphic (or table) on a certain text value of a column.

So, for example all records which contains the letters "examp" wil return all records that contains this word:

"this is an example"

"this is also an example"

But not the record:

"this is wrong written exxampple"

[Anonymous]

sum({< YOURFIELD= {"*example*"} >}  YOURMEASURE)

[fvelascog72]

Hi,

Maybe you can use the object search tool and use * to search what you want.

Cheers.

[tresesco]

I guess you need to use set analysis. Say you have a chart showing sales. You could try expression like:

=Sum({<TextField={'*example*'}>}Sales)

Assuming TextField is the name that contains your text like shown above.

[ingridmerx]

Maybe I am thinking too difficult, but the only thing I want is to filter a table in a graphic object on the content.

I want to show all the records in a text column that contains a certain group of characters.

e.g. this is the column with text records:

this is a large house

this is a big house

this is a small house

this is a larger house

I want to filter this on "large" and this should resolve in:

this is a large house

this is a larger house

[ingridmerx · Accepted solution]

I found it!

I used:

=aggr(if(NOT WildMatch(column name,'Examp*'), column name), column name)

which will give me all the records except the ones with Examp in it.

Thank you for all your replies!

[RyCarm]

Hello, I know I'm late but quick question... Where would you type this formula to get the results?