topic Re: finding a text string within another text string in QlikView

finding a text string within another text string

Mon, 14 Apr 2014 12:30:44 GMT

Hi Guys

Please see my example below.

Is there any function i can use to find or test whether Field A is found in Field B?

Field A	Field B
a	a,b,c

In this case it would be True or 1 etc.

Regards,

Magen

fkeuroglian — Mon, 14 Apr 2014 12:51:01 GMT

try wit Match()

see the example below

Good Luck

Fernando

Mon, 14 Apr 2014 13:05:15 GMT

Try the following expr:

=if(match(FieldA,subfield(FieldB,',')),1)

hope it will work..

Anonymous — Mon, 14 Apr 2014 13:07:09 GMT

try this:

if ( substringcount(FieldB, FieldA)>0, 1,-1)

1 if found

-1 if not

menta — Mon, 14 Apr 2014 13:11:54 GMT

You can use index if >0 the field A is contained in field B

index( Field B, Field A )

rbecher — Mon, 14 Apr 2014 13:13:32 GMT

This is good but you should probably use the delimiter to be save:

substringcount(',' & FieldB & ',', ',' & FieldA & ',') > 0

nizamsha — Mon, 14 Apr 2014 13:15:20 GMT

LOAD * Inline [

FieldA,FieldB

A,A

B,B;C

C,C

D,E

F,G

];

=if(Match(FieldA,SubField(FieldB,',',1)),FieldA,'Mis Match')