Search for "*" character in dataset

[#1]

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.

[giakoum]

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

[Colin-Albert]

Search for the ascii code for *  (42)

Search for      'A' & chr(42)

[Roop · Accepted solution]

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.

[#5]

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.cre...

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