Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be this
=MaxString({<Myfield = {'FCST*'}>}Myfield)
use select in field for myfield and then
=MaxString({<myfield ={"FCST*"}>}myfield)
Perfect, thanks!