Easy way to check if a certain character is a number?

[qw_johan]

Hi!

Is there an easy way to check if a certain character is a number?
Right now I am using ..
PurgeChar(str, '0123456789') as test

This works but removes all numbers from the string. What I am after isa way to check if the second character
is a number. Depending on if it's true or not, only use the first letter otherwise the complete string.

I've also tried this (no success)...
if(NumCount(str)<1, str, Left(str,1)) as test

Thanks

[#2 · Accepted solution]

Try this

if(IsNum(Left(Mid(str,2),1)),str,Left(str,1))

Thanks,

Aline

[qw_johan]

Thanks for your quick reply.
Just what I was after.

Thanks

[#4]

thanks