OR operator issue

[sifatnabil]

Hi all,

In script I have this statement:

if((match([Primary Currency],'CNH') or match([Secondary Currency],'CNH')),'Americas'

Even though the field "Secondary Currency" has a value CNH, this statement is not returning Americas. Why is this?

[Anonymous]

Hi,

If you have used the same statement as shown above, then your if statement is not closed properly. It should be

if((match([Primary Currency],'CNH') or match([Secondary Currency],'CNH'),'Americas')

[sifatnabil]

Thanks greeshma.kalathingal‌ , actually it is closed properly, I just showed you a part of my script. The part which is causing issues is this part:

if((match([Primary Currency],'CNH') or match([Secondary Currency],'CNH'))

[robert_mika]

Works for me

Can you post your full expression?

Did you try Wildmatch?

[Anonymous]

Could you share a sample file?

[tamilarasu]

Hi,

Try this,

IF(match([Primary Currency],'CNH') or match([Secondary Currency],'CNH'),'America')

Instead of yours.

America should be mentioned inside the bracket, so that if statement will show as America. You have wrongly typed outside of the if statement.

if((match([Primary Currency],'CNH') or match([Secondary Currency],'CNH')),'Americas'

See below attached example.

[Anonymous]

you can also try

if((match([Primary Currency],'CNH','Americas' if (match([Secondary Currency],'CNH')),'Americas')

[anbu1984]

Check if spaces are present in fields [Primary Currency] or [Secondary Currency]

Also check if case mentioned in if statement matches with data present in the fields

[PrashantSangle]

Hi,

Few suggestion if you want case sensitive search go with Match()

if non case sensitive search go with Wildmatch

if there is spaces in it use wild character * or trim for removing before or after spaces.

Otherwise your expression is fine for me.

Regards