topic Return Integer from a String in QlikView

Return Integer from a String

Thu, 23 Feb 2012 16:33:44 GMT

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

swuehl — Thu, 23 Feb 2012 16:42:38 GMT

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

CELAMBARASAN — Thu, 23 Feb 2012 17:15:29 GMT

Hi,

Check with this.

=mid(string,index(string,'number=')+7,7)

=Keepchar(string,'0123456789')

Celambarasan