topic Re: Fitlering a text field if it contains a specific word in SAS Visual Analytics

Filtering a text field if it contains a specific word

AleCla — Mon, 09 Jun 2014 10:29:19 GMT

Hi,

I'm not sure if this is possible or not, but thought I would raise the question. I've got a set of data which contains around 5,000 lines of free text which I would like to simply search for a specific keyword such as 'zip' or 'bow' for instance, so that the results are filtered. However, using the text input control, it only allows me to return an exact match of a string of text. Am I missing something obvious here, or is this potentially a feature on the horizon? I'm using SAS VA 6.2.

Kind regards,

Alex

Re: Fitlering a text field if it contains a specific word

AleCla — Mon, 09 Jun 2014 10:32:12 GMT

Just to add, I know this can be done by applying a manual filter if you have the authority to use the report builder options, but I want standard report viewers to be able to easily control this.

Alex

Re: Fitlering a text field if it contains a specific word

RickStyll_SAS — Tue, 10 Jun 2014 18:23:48 GMT

Hi Alex,

As you said, an on-report keyword search filter would require a filter expression created in the designer, and the keyword couldn't be modified by report consumers in the current and previous releases of Visual Analytics. However, in the upcoming 7.1 release, targeted for this fall, you will have a new parameterization capability that will enable you to create a filter control that uses additional operators, such as contains, startswith, endswith, etc. Essentially, you'll be able to create numeric and character parameters and use them in both filter and calculation expressions, among other things, and associate a parameter with input controls that you place on the report for viewers to change. To meet your text search filter requirement for report consumers in 7.1, you first create a parameter in the designer, and then a filter expression that references this parameter. Then, you associate that parameter with an input control, like the text input control. Not only does this allow you to use operators other than equality for report consumer filter selections, a parameterized filter expression allows you to have multiple filter controls that are ORed. As you likely know, multiple on-report filter controls in the viewer are implicitly ANDed in 6.4 and prior releases.

Alex, I hope this helps.

Rick Styll

Re: Fitlering a text field if it contains a specific word

AleCla — Wed, 11 Jun 2014 09:17:43 GMT

That's really useful to know, and i'll keep an eye out for it in the next version!

Many thanks,

Alex

Re: Fitlering a text field if it contains a specific word

sveinola_gundhus_tv2_no — Tue, 08 Mar 2016 23:40:20 GMT

Is there now a "how to guide" on how to do this?

Im struggeling with how to create the parameter to obtain this.

Trport with a textbox where user enters value -> report filtered by user entry where variable contains "user entry text"

Your help is much obliged

Re: Fitlering a text field if it contains a specific word

Sam_SAS — Wed, 09 Mar 2016 14:52:19 GMT

Hello,

To create the parameter, you can right-click the Parameter heading in the filter editor and select Create Parameter. Then you can use the parameter in your filter expression, which might look something like 'Body'n Contains 'Parameter 1'p

To enable the viewer to specify the parameter value, create a "text input" control and assign the parameter to the Parameter role for the text input control.

Does that help?

Thanks,

Sam

Re: Fitlering a text field if it contains a specific word

sveinola_gundhus_tv2_no — Wed, 09 Mar 2016 18:53:58 GMT

Hi,

Thank you very much. This was great help.

Svein

Re: Fitlering a text field if it contains a specific word

maverickkub — Thu, 16 Feb 2017 05:13:41 GMT

Thank you so much,this was really Helpful!!!!