Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to determine if 5th character is a number

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

1 Solution

Accepted Solutions
Employee
Employee

Re: How to determine if 5th character is a number

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

4 Replies
Employee
Employee

Re: How to determine if 5th character is a number

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

stigchel
Honored Contributor

Re: How to determine if 5th character is a number

Try with something like

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

Not applicable

Re: How to determine if 5th character is a number

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

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

Not applicable

Re: How to determine if 5th character is a number

Thank you - this works as well

Community Browser