Match Not working

[Anonymous]

Hi

I am trying to match a field with the selections made for that field but it's not working and i  can't see what I am doing wrong.

The field is BGCompany which contains '[Acc - Superbia]'

The Selections for the field contains '[Acc - New Heights],[Acc - Superbia] ' using =GetFieldSelections(BGCompany,',',50)

The Match statement used is =Match(BGCompany,GetFieldSelections(BGCompany, ',',50))  which returns 0 where I am expecting something > 0.

I am sure that I am missing something very simple, please help.

[vamsee]

Hi George,

Try

If your looking for count

=SubField(GetFieldSelections(BGCompany,','), 'of',1)

If you are looking for values

=SubField(GetFieldSelections(BGCompany,',',50), 'of',1)

[vishsaggi · Accepted solution]

may be try this?

= Substringcount(BGCompany, GetFieldSelections(BGCompany))

[Anonymous]

Thanks for the answers this worked I just had to reverse the order of the parameters

Substringcount( GetFieldSelections(BGCompany),BGCompany)

Happy Me