List box only need alphabetic

[everest226]

HI i have a list box with numerical and alphabetical value,  how to show only alphabetical value.

asd

hsbd

dfd

251

152544

sdfd 

[sunny_talwar · Accepted solution]

May be this

If(IsText(Field), Field)

[vishsaggi]

May be this?

In your listbox General tab -> Field - Expression

= IF(ISNUM(Alphabet), Null(), Alphabet)

OR

= IF(NOT IsNum(Alphabet), Alphabet)

[everest226]

Thanks both of you it worked.

[Chanty4u]

may be try this way

a:

LOAD*, PurgeChar(MyField,'01234567890') as New;

LOAD * INLINE [

MyField

    asd

    hsbd

    dfd

    251

    152544

    sdfd

];