Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Can you please let us know what is the meaning of
I want to filter the values other than numbers in one field ...
hi
try like this
purgechar ( 'a1b2c3','123' ) returns 'abc'
You can use:
purgechar (yourfield, '01234567890')
try this demo
LOAD PurgeChar(field,'0123456789') as newfield;
load * Inline [
field
ab1
012df
gh5j
]
Try this
purgechar (yourfield, '01234567890') --> To get Text Values
keepchar (yourfield, '01234567890') --> To get numerical Values
Regards
ASHFAQ
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"
Hi MRKachhiaIMP ,
If you understand the expression i used for that listbox ..you will know what i want..