Searching for a specific string

[#1]

Hi All,

I have a question regarding searching for a specific string.

Lets say I have data:

table1:

KEY	CODE
ABC	AB
DEF	DE
XYZ	XY

table2:

KEY	FIELD1
ABC	G-H-G-H-G-A-B-AB-ABC
DEF	AB-AB-DE-EF
XYZ	ABC-XY-QYZ

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]

How about:

FindOneOf(text , characterset [ , n])

so in your example,

FindOneOf('AB', FIELD1)

if zero is returned it cannot find it.

[alexandros17]

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;

[#4]

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

[sudeepkm · Accepted solution]

you can use like below. Please find the attachment.

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

[#6]

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