topic Re: Search for "*" character in dataset in QlikView

Search for "*" character in dataset

Tue, 03 Mar 2015 14:02:35 GMT

Hi,

We have two sample sets of data (string format). One of them is rather normal, second has got "*" character in string in some rows. When we use set analysis to select rows which begins with letter A from first dataset we use:

{<Nazwa={"A*"}>} Nazwa (we get all rows for field "Nazwa" that begins with letter A

In second dataset I use exactly same set analysis expression but when I have datarow with "*" character it gives another result. And that is correct probably but is there any way to search with that method over this kind of dataset?

Without changing "*" in source strings to another symbol?

Example in attachement - that should be clear.

Re: Search for "*" character in dataset

giakoum — Tue, 03 Mar 2015 14:08:45 GMT

use replace function to create a new field in your reload script where you replace * with some other char

Re: Search for "*" character in dataset

Colin-Albert — Tue, 03 Mar 2015 14:09:10 GMT

Search for the ascii code for * (42)

Search for 'A' & chr(42)

Re: Search for "*" character in dataset

Roop — Tue, 03 Mar 2015 16:10:39 GMT

You can use FindOneOf(Nazwa,'*')

It will return a positive value for the first position it finds. This may be a more versatile method incorporated into your dataset manipulation.

Re: Search for "*" character in dataset

Thu, 05 Mar 2015 13:54:24 GMT

Hi, thanks!

I found also alternative for that in thread:

http://community.qlik.com/blogs/qlikviewdesignblog/2015/03/02/the-search-string?et=blogs.comment.created#comment-26321

posted by Rob: "=index(Nazwa,'*')>0"