topic Re: Searching for a specific string in QlikView

Searching for a specific string

Thu, 22 May 2014 13:44:32 GMT

Hi All,

I have a question regarding searching for a specific string.

Lets say I have data:

table1:

table2:

In Key ABC, I have to find the CODE (AB) in FIELD1 (G-H-G-H-G-A-B-AB-ABC).

How do I do this?

Thanks,

Lyn

Roop — Thu, 22 May 2014 13:49:13 GMT

How about:

FindOneOf(text , characterset [ , n])

so in your example,

FindOneOf('AB', FIELD1)

if zero is returned it cannot find it.

alexandros17 — Thu, 22 May 2014 13:49:53 GMT

Try this code

TMP:

NoConcatenate

Load * resident Table1;

join

Load * resident Table2;

TABLE:

LOAD *, If(WildMatch(CODE, FIELD1) > 0, 'OK', 'NO') as is_in_field Resident TMP;

DROP Table TMP;

Thu, 22 May 2014 13:52:51 GMT

And how should your result look like? You need to show starting position of this CODE in FIELD1?

sudeepkm — Thu, 22 May 2014 13:53:02 GMT

you can use like below. Please find the attachment.

if(SubStringCount(FIELD1,CODE)>0,'PRESENT','ABSENT') as CODEFLAG

Thu, 22 May 2014 14:10:47 GMT

Hi,

thanks this is what I'm looking for. My other question is, what if field1 contains ACB instead of ABC, how can I fix it in alphabetical order?

Thanks,

Lyn