3 Replies Latest reply: Apr 20, 2017 12:50 PM by Claudio Bueno RSS

    Search for string in listbox

    Claudio Bueno

      Hi guys,

       

      I need to put an action in a button to filter a listbox with the string 'FCST'. This listbox contains values like 'FCST1', 'FCST2', 'FCST1', 'BGT' etc.

      The problem is, I need to get the maximum nr. after 'FCST', in that case 'FCST3'.

       

      Something like that: (but doesn't work..)

      =If(Max(Right(WildMatch(Myfield,'FCST*'),1)),Myfield)

       

      Any thoughts?