Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to apply the Match function.
These are the fields & Values:
TmpOrder_Type :SLS
ConcatExcludeOrderTypes: 'SLS','SRV'
The expression Match(TmpOrder_Type, ConcatExcludeOrderTypes) displays 0.
Can someone help me figure out why?
Thanks!
Hi @DanaL
Try with Index or Substringcount
=SubStringCount(ConcatExcludeOrderTypes,TmpOrder_Type)
returns 1
Hi @DanaL
Try with Index or Substringcount
=SubStringCount(ConcatExcludeOrderTypes,TmpOrder_Type)
returns 1
That works..
Thank you!
Any idea why the Match doesn't?
HI @DanaL
Match function returns true when its exactly both values are same.
For ex:
match('Apple', 'Apple') returns 1
Hi,
Please notice the example from Help
Hi @DanaL
FYI,
Your ConcatExcludeOrderTypes field has single values with combined string i.e. 'SLS','SRV'.
In Help, Jan, Feb, Mar are 3 individual values.. its not a single string.
Hi,
What's the difference between the values?
In both cases they look the same, no? 'SLS','SRV' vs 'Jan','Feb'
HI
In List box, you can see the values like below for your ConcatExcludeOrderTypes
SLS,SRV
Month Field likes
Jan
Feb
Match function will return true when its exactly match, else return false.
Suppose, if TmpOrder_Type field also has single value like SLS,SRV, then it return true.
Now I get it 🙂
Thanks for clarifying!