How to filter rows where value is not a number?

[#1]

Hi all,

I have the following table

aaaa

34

22.2

drr

and I would like to filter number rows so I obtain

24

22.2

Any hint?

[jagan]

Hi,

Try like this

LOAD

*

FROM Data

Where IsNum(Value);

Hope this helps you.

Regards,

Jagan.

[#3]

Hi,

Hope this will help you.

[rustyfishbones]

You WHERE ISNUM(Value);

like below