Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You are on the right track, use the mid() function to get your numbers:
=mid(string,index(lower(string),'stringnumber=')+13,7)
Hope this helps,
Stefan
You are on the right track, use the mid() function to get your numbers:
=mid(string,index(lower(string),'stringnumber=')+13,7)
Hope this helps,
Stefan
Hi,
Check with this.
=mid(string,index(string,'number=')+7,7)
or
=Keepchar(string,'0123456789')
Celambarasan