Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a listbox which has a couple of records that start with %.
I want to filter records that start with % ,not just get rid of the % symbol but the whole record if it starts with %.
I tried using
=trim(PurgeChar(%AF_FeildName,'%'))
The above just gets rid of '%'
then tried using
replace(%AF_FeildName,'%',null())
with hope that ,I can multiply that record with null(),then suppress nulls() in the listbox
Note: I want to implement the logic in front end not backend
Use
if(mid(Fieldname,1,1)<>'%', Fieldname)
use an expression for listbox
=if(not WildMatch(%AF_FeildName, '%*'), %AF_FeildName)