11 Replies Latest reply: Apr 11, 2018 4:57 AM by dion verbeke RSS

    Expression Possibility

    Jamel Messaoud

      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