Is there any function in QlikView that would tell if there is a numeric value in a string?

[#1]

Hi All,

Is there any function in QlikView that would tell if there is a numeric value  in a string?

Eg. 'FP00731' has a numeric value and 'APPLE' does not.

Thanks,

Neeraj

[#2 · Accepted solution]

Hi,

I don't know if a function like that exists, but instead you can use the function keepchar(value, '1234567890'), if the value is 'FP00731' the function returns 00731 so then you can use an 'IF' to validate if the was a number in the string, something like:

if(keepchar(value, '1234567890') = '', 'No numeric', 'Numeric')

Hope this helps

Regards!

[#3]

Thank you so much Gabriela !!

It is just the solution I was looking for .

Regards,

Neeraj