"like" in Stage Variables

ORACLE_1 · Post by **ORACLE_1** » Tue Aug 17, 2010 9:45 am

Hey Guys ,

I want to compare the incoming data to a specified value , something like this -

input like '%XYZ%' or input like '%ABC%'

in the stage variable and assign it a value if it matches , if not then assign it another value. I am not sure which function I can use to accomplish this , please help !

chulett · Post by **chulett** » Tue Aug 17, 2010 9:47 am

Index()

arunkumarmm · Post by **arunkumarmm** » Tue Aug 17, 2010 9:55 am

Or you can even use Count...

anbu · Post by **anbu** » Tue Aug 17, 2010 9:58 am

Or Matches

ORACLE_1 · Post by **ORACLE_1** » Tue Aug 17, 2010 10:20 am

Thank You !!

kumar_s · Post by **kumar_s** » Tue Aug 17, 2010 11:11 am

anbu wrote:Or Matches

Matches at Version 7?!
Anyway the topic is resolved

chulett · Post by **chulett** » Tue Aug 17, 2010 12:33 pm

"Matches" has been there basically forever, I do believe.

rameshrr3 · Post by **rameshrr3** » Tue Aug 17, 2010 3:10 pm

input like '%XYZ%' or input like '%ABC%'

you may try

Code: Select all

input Matches "...XYZ...":@VM:"...ABC..."

to match multiple wildcard patterns

Also Matches is an Expression , not a BASIC Function , and hence havent heard of Matches() ( in v7 or later

)..

But I Wish something similar would exist in DS Parallel Xtender ..

chulett · Post by **chulett** » Tue Aug 17, 2010 4:23 pm

Ahhh... revisionist history is a wonderful thing.

rameshrr3 · Post by **rameshrr3** » Tue Aug 17, 2010 6:16 pm

revisionist history

Did I forget to mention that the 'revisionist history' feature also gets a few bonus points ..