alphanumeric values in listbox

[sibideepak]

Hi ,

I have Number field which contains mixed values like 001,AB1,005,etc...

I want to filter the values other than numbers in one field ...

I used the following expression which work as my desire but it shows only value select other are

hidden because of only function, i want the listbox which always shows the alphanumeric value.

=aggr(only({<Number-={"=if(isnum(Number),Number)"}>}Number),Number)

[MK_QSL]

Can you please let us know what is the meaning of

I want to filter the values other than numbers in one field ...

[#3]

hi

try like this

purgechar ( 'a1b2c3','123' ) returns 'abc'

[ecolomer]

You can use:

purgechar (yourfield, '01234567890')

[#5]

try this demo

LOAD PurgeChar(field,'0123456789') as newfield;

load * Inline [

field

ab1

012df

gh5j

]

[ashfaq_haseeb]

Try this

purgechar (yourfield, '01234567890')  --> To get Text Values

keepchar  (yourfield, '01234567890')  --> To get numerical Values

Regards

ASHFAQ

[Anonymous]

if you use purgechar(Numberfield,'0123456789') you only get the part without numbers

you say you want a listbox containing all non numeric fields

can you use an Expression in the listbox with the purgechar function?

in the listbox you will always see all values (some green, some white, some gray)
as Long as you didnot select "exclude"

[sibideepak]

Hi MRKachhiaIMP ,

If you understand the expression i used for that listbox ..you will know what i want..