If and Match in Script

[psk180590]

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.

[Chanty4u]

try like this

If(Match([FNum],'140','150','160','170') and Match([Anum],'*'), 'Fnum', Anum)

[jwjackso]

If(Match(FNum,'140') and Match(ANum,Chr(42)),1,0) as Absolut_N;

[wdchristensen]

Might want to verify that [Anum] is not null. The * matches non-null values.

[psk180590]

Both the solutions don't work for me. They give 0 as result

[PrashantSangle]

Can you be more specific with Anum with *

what are you trying to do??

can you explain with sample file??

Regards,

[Peter_Cammaert]

First things first: what is it that you want to test? And what does your data look like?

[jwjackso]

What are the possible values for Anum?

[Chanty4u]

may be

if(match(FNum,'140','150','160','170') ,'Yes',if(Match(ANum,'*'),'No',''))  as   Newfield

[wdchristensen]

If(Match([FNum],'140','150','160','170'), If(Match([Anum],'*', 1, 0)), -1) as Absolut_N