2 Replies Latest reply: Nov 2, 2016 6:49 PM by Marco Wedel RSS

    Substr and Instr in Qlikview?

    Jason Liau

      Having a tough time translating this SQL function to work as a load in Qlikview:

      lower(substr(EMAIL_ADDRESS,instr(EMAIL_ADDRESS,'@'),length(EMAIL_ADDRESS))) "Email Domain"

       

      essentially I'm loading just the @xxxxx.xxx of the email.

       

      Any help would be greatly appreciated, thanks!

       

      -Jason