Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I'm looking to have multiple match conditions in my script.
Ex: if(match(FNum,'140','150','160','170') and Match(ANum,'*'),1,0)as Absolut_N
The First Match works fine but, the second with * doesn't work. Please, help me on how to include * in a Match condition.
Regards
Sai.
try like this
If(Match([FNum],'140','150','160','170') and Match([Anum],'*'), 'Fnum', Anum)
If(Match(FNum,'140') and Match(ANum,Chr(42)),1,0) as Absolut_N;
Might want to verify that [Anum] is not null. The * matches non-null values.
Both the solutions don't work for me. They give 0 as result
Can you be more specific with Anum with *
what are you trying to do??
can you explain with sample file??
Regards,
First things first: what is it that you want to test? And what does your data look like?
What are the possible values for Anum?
may be
if(match(FNum,'140','150','160','170') ,'Yes',if(Match(ANum,'*'),'No','')) as Newfield
If(Match([FNum],'140','150','160','170'), If(Match([Anum],'*', 1, 0)), -1) as Absolut_N