Function to check Alphanumeric Codes

[#1]

Hi!

Is there a function in qlikview through which i can check whether my Code is Aplhanumeric or not.

Actually i have a data which have alphanumeric codes and i want to remove them while loading the data in qlikview and the alpabets in the codes are at random locations.

Thanks in advance .

Rahul..

[deepakk]

hi Rahul,

Use num function if it returns null value then it means it contains characters.

eg

num('asd984') will return -

if(num('asd984') =-1,0,1)

I hope this helps.

[deepakk]

opss.. the code should be

if(isnull(num('er454')) =-1,0,1)

[#4]

Hi!

If you only want to find out if a field is numeric or not you can use the isnum() function.

Kind regards

Lars

Brait AB