Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a field, and it should just contain numbers - however due to the data structure it possible that the field contains text. If so, I want to be able to mark and/or filter these rows.
Regards,
Use IsNum()/IsText() functions
Use IsNum()/IsText() functions
with isnum(). for example:
load Value, isnum(Value) as IsNum inline [
Value
1
2
a
b
4
w
?
]
Just as amit ray and Alejandro Hernandez suggest, you can use IsNum().
However, if you have texts like '3E4', these will be marked as TRUE by IsNum(), since it is a correct scientific numeric format. If you have such texts, it may be better to use
Len(Purgechar(Value, '0123456789.'))=0
as test.
HIC