finding a text string within another text string

[#1]

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]

Hi

try wit Match()

see the example below

http://qlikshare.com/292/

http://community.qlik.com/message/483096#483096

Good Luck

Fernando

[#3]

Try the following expr:

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

hope it will work..

[Anonymous]

try this:

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

1 if found

-1 if not

[menta]

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

index( Field B, Field A )

[rbecher]

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

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

[nizamsha]

LOAD * Inline [

FieldA,FieldB

A,A

B,B;C

C,C

D,E

F,G

];

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