topic Function to check Alphanumeric Codes in QlikView

Function to check Alphanumeric Codes

Tue, 01 Feb 2011 12:19:55 GMT

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..

Function to check Alphanumeric Codes

deepakk — Tue, 01 Feb 2011 12:27:20 GMT

hi Rahul,

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

num('asd984') will return -

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

I hope this helps.

Function to check Alphanumeric Codes

deepakk — Tue, 01 Feb 2011 12:28:32 GMT

opss.. the code should be

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

Function to check Alphanumeric Codes

Tue, 01 Feb 2011 12:28:42 GMT

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