Expression Possibility

[jamelmessaoud]

Hi guys,

Can you do something in Qlik via a function/expression to determine if a character in a field is either a text or a number.

I have some postcode data like

• LA2
• L40

I want to be able to say if the first character is a letter and the second is a number then do something.  If the first character is a letter and the second character is also a letter then do something else..

Is there a function to do this by any chance?

Thanks

J

[Anonymous]

Apologies if it looks like that. But Teis, my expression is different than yours. Yours will not work.

isnum(Left( Postcode, 2)) - will never return true. Since L4 will always be Text.

Thank you though for the kudos

Rgds,

B

[jamelmessaoud]

That is correct. I tried the expression which Teis submitted first and it didn't work.  However the expression from Benazir did !