topic Searching for WildCard Characters in QlikView

Searching for WildCard Characters

jlassell — Tue, 23 Feb 2010 14:45:32 GMT

How can you search in a field for an "*" (asterisk)? -- or any wildcard at all?

I would also like to be able to create a button that has an action which Selects any of the following characters in a field (quote mark, double quote mark, tick, pipe, asterisk, question mark).

Any ideas?

Thanks,

-Jeff

Searching for WildCard Characters

Tue, 23 Feb 2010 15:38:47 GMT

This came up in a recent thread. http://community.qlik.com/forums/p/22182/85125.aspx

The users came up with some pretty good ideas. I think in the end it was using: ?*?. A macro solution was also provided.

Searching for WildCard Characters

jlassell — Tue, 23 Feb 2010 16:48:18 GMT

That helps. It got me on the right track.

I was able to use =FindOneOf( mval, '?~*" ' ) to find the values with these characters. The one thing I can't put in is the ' (single quote mark). I would still like to be able to do that.

I also cannot get the same solution to work in a Select field Action in a Button.

Searching for WildCard Characters

Tue, 23 Feb 2010 17:23:21 GMT

Chr(39) is the code for a single quote. Did you try:

=FindOneOf( mval, '?~*" ' & Chr(39))

Searching for WildCard Characters

jlassell — Tue, 23 Feb 2010 19:36:43 GMT

That works for a direct search in the List Box. Thanks!

I wish I could get it to work on the Field Selection for an Action.

Searching for WildCard Characters

Anonymous — Thu, 24 Mar 2011 15:30:34 GMT

Try replacing the * by a +. This worked for me.

Replace([field],'*','+') as [fieldII]