List box with filter condition

[ramasaisaksoft]

Hi Team,

i have a list box with numbers and characters ex :-(1,2.3.4,5,~71,@89....ant,ball,cat,donkey,ele...etc) like this i have > 17000 records but characters words are only 95 records so i want to show those 95 in UI for end user

Now my query is there any way to show only characters

In advance thanks for your  valuable help.

[anbu1984 · Accepted solution]

Try this expr in listbox

=If(Len(PurgeChar(Field,'0123456789')) = Len(Field) , Field)

[Anonymous]

Hello Rama Sai,

Could you post sample records?

Ravi N.

[arulsettu]

hi try this

=KeepChar(field,'abcdefghijklmnopqrstuvwxyz')

[MarcoWedel]

KeepChar(field, 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ')

[ramasaisaksoft]

Thanks to all i got the solution like this

=If(IsNum([Department Name]) <> -1 And Len(PurgeChar([Department Name],'0123456789')) = Len([Department Name]) , [Department Name])

Appreciate every one individually.

[anbu1984]

Can you close the post by marking correct/helpful answers