topic Re: Extract part of the string in QlikView

Extract part of the string

Thu, 23 Jul 2015 13:57:53 GMT

Hi All,

I have Field contains the values with '&'. This '&' could be anywhere in the string, but I want to extract the string between last and second last '&'

for eg. I have string like abc&xyz&pqr&ghi

I want the value pqr

Re: Extract part of the string

Kushal_Chawda — Thu, 23 Jul 2015 14:00:42 GMT

something like this

= mid(Field, Index(Field,'&',-2)+1, Index(Field,'&',-1) -(Index(Field,'&',-2)+1))

Re: Extract part of the string

sunny_talwar — Thu, 23 Jul 2015 14:07:43 GMT

You can also try this:

=SubField('abc&xyz&pqr&ghi', '&', Index(KeepChar('abc&xyz&pqr&ghi', '&'), '&', -1))

Output is pqr here

Re: Extract part of the string

antoniotiman — Thu, 23 Jul 2015 14:16:25 GMT

=SubField('abc&xyz&pqr&ghi','&',-2) -> pqr

Re: Extract part of the string

Thu, 23 Jul 2015 14:30:22 GMT

thanks. all are working

Re: Extract part of the string

sunny_talwar — Thu, 23 Jul 2015 14:33:08 GMT

I agree all solution are working, but I would suggest using ANTONIO‌'s solution as it is the most straight forward of the three.

Best,

Sunny

Re: Extract part of the string

Kushal_Chawda — Thu, 23 Jul 2015 18:41:32 GMT

Even I agree with sunindia , use AntonioTiman solution