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?