How to get the individual Field values matching a (wildcard) search?

[m_r_de_wit]

Dear fellows,

I'm having a problem getting all field values matching the (wildcard) search.

I started using the GetCurrentSelections, this functions works fine, as I show in the example below, when I'm selecting multiple values in a List Box by clicking upon the values I need.

But when I make a selection using the (wildcard) search, I don't get hold on the selected values individually. All functions I used so far return the search string I've entered. See the example below.

Anyone who has any idea of a funtion to get the individual field values which match the entered search criterium?

Kind regards, Michel

[swuehl · Accepted solution]

Maybe like

=If(GetSelectedCount(FIELD), CONCAT(DISTINCT FIELD,':') )

[m_r_de_wit]

Perfect, just what I was looking for. Thnx a lot.