Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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')
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'))
Works for me
Can you post your full expression?
Did you try Wildmatch?
Could you share a sample file?
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.
you can also try
if((match([Primary Currency],'CNH','Americas' if (match([Secondary Currency],'CNH')),'Americas')
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
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