Page 1 of 1
"like" in Stage Variables
Posted: Tue Aug 17, 2010 9:45 am
by ORACLE_1
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 !
Posted: Tue Aug 17, 2010 9:47 am
by chulett
Index()
Posted: Tue Aug 17, 2010 9:55 am
by arunkumarmm
Or you can even use Count...
Posted: Tue Aug 17, 2010 9:58 am
by anbu
Or Matches
Posted: Tue Aug 17, 2010 10:20 am
by ORACLE_1
Thank You !!
Posted: Tue Aug 17, 2010 11:11 am
by kumar_s
anbu wrote:Or Matches
Matches at Version 7?!
Anyway the topic is resolved
Posted: Tue Aug 17, 2010 12:33 pm
by chulett
"Matches" has been there basically forever, I do believe.
Posted: Tue Aug 17, 2010 3:10 pm
by rameshrr3
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 ..
Posted: Tue Aug 17, 2010 4:23 pm
by chulett
Ahhh... revisionist history is a wonderful thing.
Posted: Tue Aug 17, 2010 6:16 pm
by rameshrr3
revisionist history
Did I forget to mention that the 'revisionist history' feature also gets a few bonus points ..