Searching for WildCard Characters

[jlassell]

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

[#2]

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.

[jlassell]

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.

[#4]

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

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

[jlassell]

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.

[Anonymous]

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

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