Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If(Not IsNum(Country), Country) .. then enable 'suppress when value is null'
Or for specific names:
If(Match(Country, 'Ghana', 'INDIA, 'UK'), Country)
If(Not IsNum(Country), Country) .. then enable 'suppress when value is null'
Or for specific names:
If(Match(Country, 'Ghana', 'INDIA, 'UK'), Country)
Hi,
something like this should work :
choose expression and then :
=only({<Countries = {"=not(isNum(Countries))"} >}Countries)
regards
You can use an approach like the one i included in this app:
where you want to do ? in front end or in back ends?
try with string function like purgechar() or keepchar().
regards,
Hi Tresesco
Brilliant it worked like a charm thank you very much.
Thanks Dimitrios it is worked as well,I chose Tresesco solution but thank you very very much i really appreciate you help.
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.
Hi Tresesco
Brilliant it worked like a charm thank you very much.