How to ignore some values in listbox

[mandilicious]

Hi All

Please help i need to ignore numbers and only display countries in my list box.

I  don't  want to see 100,101,102,103. i  only want  Ghana,INDIA,UK in my list box.

Thanks

[tresesco · Accepted solution]

If(Not IsNum(Country), Country)  .. then enable 'suppress when value is null'

Or for specific names:

If(Match(Country, 'Ghana', 'INDIA, 'UK'), Country)

[ogautier62]

Hi,

something like this should work :

choose expression and then :

=only({<Countries = {"=not(isNum(Countries))"} >}Countries)

regards

[dapostolopoylos]

You can use an approach like the one i included in this app:

[PrashantSangle]

where you want to do ? in front end or in back ends?

try with string function like purgechar() or keepchar().

regards,

[mandilicious]

Hi Tresesco

Brilliant it worked like a charm thank you very much.

[mandilicious]

Thanks Dimitrios it is worked  as well,I chose Tresesco solution but thank you very very much i really appreciate you help.

[mandilicious]

Thank you very much it is worked as well,just that i I chose Tresesco solution but thank you very very much i really appreciate you help.

[mandilicious]

Hi Tresesco

Brilliant it worked like a charm thank you very much.