Check whether the value is number or not

[#1]

Hi everyone,

I load some large Excel documents with numeric value and then show them in table chart.

I would like to make control on load to check if somebody enter letter in Excel document.

It would be the best If I could show that field in some table to know what I should rewrite.

Any help is welcome.

Tnx

[alexandros17 · Accepted solution]

There are some functions thata test if a value is Numerical or is Null

Isnum(Value)

IsNull(Value)

when you load your data you can set flags something like

Load

...

if(isnum(myField), myField, 'X') as myFieldFlag

...

in this way all values having 'X' will contains wrong values

[#3]

Tnx for reply,

I will check now

[SlimJim]

Simple IsNum may not always work. Try this also:

isnum( Num# (Field) )