Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
below if condition is not working for me, kindly please suggest.
if(Match(trim([Product Code]),'3')and [Product Code]='3', 'text', 'text1')
Thanks,
NR
Hi,
Trim function removes spaces near value, so I assume that you have spaces, for instance
' 3' or ' 3 '
In this case, the first part of your expression returns true because trim removes spaces and you get '3'
Match(trim([Product Code]),'3')
But the second part returns false because the Product Code value still contains spaces
[Product Code]='3',
You can just replace your condition by following:
if(trim([Product Code]) = '3', 'text', 'text1')
Regards,
Vitalii
Hi Vitalli,
Thanks for your quick response, i tried with option but still not working. any other set analysis/other options.
if([Product Code]='3' or Match(trim([Product Code]),'3'),'text','text1')
Regards,
NR
Could you please share your result? I don't understand where you try to use this condition in the UI or in the script part.
Regards,
Vitalii