
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Check whether the value is number or not
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
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Tnx for reply,
I will check now

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Simple IsNum may not always work. Try this also:
isnum( Num# (Field) )
