Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hello,
Use "LIKE" keyword when using wildcards as follows
If(GetFieldSelections(VIEW) LIKE '*ear*', 'Found', 'Not Found')
This should work
Hello,
Use "LIKE" keyword when using wildcards as follows
If(GetFieldSelections(VIEW) LIKE '*ear*', 'Found', 'Not Found')
This should work
Yes, it works. Thanks.
I also found another solution:
=IF(SUBSTRINGCOUNT(GETFIELDSELECTIONS(View,''), 'Year-1') >0, 'Found', 'Not Found')
Many thanks.