How to determine if 5th character is a number

[#1]

Hey All,

I am trying to determine if the 5th character in a string is a number. Some field values are TEST##### and some are TESTxxxx if TEST# then I want to show, if TESTx I want to hide.

Thanks,

Vince

[Clever_Anjos · Accepted solution]

IsNum(mid('TESTxxxx',5,1))

[stigchel]

Try with something like

IsNum(mid('abcd1fg',5,1))

[#4]

Thank you - I figured it was that simple!!!!!

Couldn't get my brain around it!!!!!!

[#5]

Thank you - this works as well