Match a field with Concatenated values

[DanaL]

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!

[MayilVahanan · Accepted solution]

Hi @DanaL 

Try with Index or Substringcount

=SubStringCount(ConcatExcludeOrderTypes,TmpOrder_Type)

returns 1

[DanaL]

That works..

Thank you!

Any idea why the Match doesn't?

[MayilVahanan]

HI @DanaL 

Match function returns true when its exactly both values are same. 

For ex:

match('Apple', 'Apple') returns 1

[DanaL]

Hi,

Please notice the example from Help

[MayilVahanan]

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.

[DanaL]

Hi,

What's the difference between the values? 

In both cases they look the same, no? 'SLS','SRV' vs 'Jan','Feb'

[MayilVahanan]

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. 

[DanaL]

Now I get it 🙂

Thanks for clarifying!