alphanumeric vs. numeric

[Iris Gesser]

Hello,

can you help me please?
I have to find out if a character variable inside is alphanumeric or numeric.
Is there an easy command, that I can use?

Thank you in advance, kind regards
Iris

[ukoenig]

Hallo Iris,

I have to find out if a character variable inside is alphanumeric or numeric.

VAL returns the info You are looking for

Msgalert( VAL( "aaa" ) ) = 0
Msgalert( VAL( "111" ) ) = 111

best regards
Uwe

[Iris Gesser]

Hello Uwe,

thank you for your answer.
I have tried with VAL, but this is not the solution.

local cNumber = "1S2673Z"
msginfo(VAL(cNumber)) = 1

I think VAL evaluates cNumber until the first non-numeric character.

Thank you and kind regards
Iris

[Natter]

cVar:="a5b"
posrange(chr(48), chr(57), cVar) - 2

[cnavarro]

Try with

Code: Select all  Expand view  RUN

   ? hb_IsNumeric( <var> )
 

[Iris Gesser]

Thank you very much, this is wotking fine!
Kind regards
Iris