Wildcard filter in list box?

[swarup_malli]

Hi,

    I have a list box, I want it to only show records starting with BEL..and exclude all others that don't start with BEL

Lets say the dimension name is MODEL_CODE.

MS

[Gysbert_Wassenaar]

Try this expression for the listbox:

=aggr(if(left(MODEL_CODE,3)='BEL',MODEL_CODE),MODEL_CODE)

[#3 · Accepted solution]

Hi,

Try with this:

If(left(FieldName, 3) = 'BEL', FieldName)

Regards,

Ricardo

[MayilVahanan]

Hi

PFA

Hope  it helps

[swarup_malli]

Thank you again Gysbert,

though the solution you gave, eliminates any model other than BEL, but when I make a selection on listbox(with the expression =aggr(if(left(MODEL_CODE,3)='BEL',MODEL_CODE),MODEL_CODE)) ,all the other values disappear, ie only one value appears in the list box, I want the list box to show other BEL models

MS

[Gysbert_Wassenaar]

Remove the aggr: =if(left(MODEL_CODE,3)='BEL',MODEL_CODE)

[swarup_malli]

I tried this code in the script editor

IF(model_code like 'BEL',1,0) as flag_model_code

But the thing is its also showing records starting with "Bel"..I want BEL..and not Bel..cos el is lower case

[swarup_malli]

Hi Mayil,

    Thank u , but its not case sensitive, I want it to eliminate "Bel"    Cos el is lower case, only records starting with BEL should be fished out.

Can it be done ?

Thanks

SM

[MayilVahanan]

HI

Then try like this

If(Left(MODEL_CODE,3)='BEL',MODEL_CODE) As MODEL_CODE

Hope it helps