2 Replies Latest reply: Feb 23, 2012 12:15 PM by Celambarasan Adhimulam RSS

    Return Integer from a String

      Should be a simple task:

       

      I have a standard string. When a certain sequence occurs in the string, I want to return the next 7 integers in the string. For example:

       

      String = "thisisastringthisisastringthisisastringstringnumber=1234567thisisastringthisisastring"

       

      In this case I was to return the value "1234567"

       

      So far what I got is this: if(index(lower(string), 'stringnumber='),...

       

      How do I tell Qlikview to find me those numbers in this statement?

       

      Eric