Search for string in listbox

[Anonymous]

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?

[sunny_talwar · Accepted solution]

May be this

=MaxString({<Myfield = {'FCST*'}>}Myfield)

[Anonymous]

use select in field for myfield and then

=MaxString({<myfield ={"FCST*"}>}myfield)

[Anonymous]

Perfect, thanks!