Filter records that start with % in the listbox

[Anonymous]

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

[reshmakala · Accepted solution]

Use

if(mid(Fieldname,1,1)<>'%', Fieldname)

[maxgro]

use an expression for listbox

=if(not WildMatch(%AF_FeildName, '%*'), %AF_FeildName)