getfieldselections with wildcard

[#1]

Hi all,

Using the getfieldselections function how can I combine it with a wildcard? For example:

getfieldselections(VIEW) = 'Year-1'

so I need to use the wildcard to search the text string so that when more than one selection is made from VIEW, TRUE is returned providing Year-1 is one of the selections. I tried this:

getfieldselections(VIEW) = *'Year-1'* but it didn't work.

Any suggestions?

Many thanks as always.

[Miguel_Angel_Baeyens · Accepted solution]

Hello,

Use "LIKE" keyword when using wildcards as follows

If(GetFieldSelections(VIEW) LIKE '*ear*', 'Found', 'Not Found')

This should work

[#3]

Yes, it works. Thanks.

I also found another solution:

=IF(SUBSTRINGCOUNT(GETFIELDSELECTIONS(View,''), 'Year-1') >0, 'Found', 'Not Found')

Many thanks.