Discussion Board for collaboration related to Creating Analytics for QlikView.
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?
Go to Solution.
You are on the right track, use the mid() function to get your numbers:
Hope this helps,
Check with this.