topic Re: Extracting from a big line in QlikView

Extracting from a big line

Anonymous — Mon, 08 Jun 2015 14:17:23 GMT

CN=Vijay Kumar,OU=Standard,OU=Users,OU=Madras,OU=Sites,OU=iWay,DC=ap,DC=corp

Hi Friends,

In the above line we multiple OU=

I would like to extract Madras from OU=Madras.

How can I do this?

Re: Extracting from a big line

Anonymous — Mon, 08 Jun 2015 14:24:07 GMT

Try

TextBetween(BigLine, 'OU=', ',', 3)

Where 3 points to the 3rd occurrence of 'OU='

Re: Extracting from a big line

Anonymous — Mon, 08 Jun 2015 14:34:14 GMT

if it just madras you can use

=mid('CN=Vijay Kumar,OU=Standard,OU=Users,OU=Madras,OU=Sites,OU=iWay,DC=ap,DC=corp' ,index('CN=Vijay Kumar,OU=Standard,OU=Users,OU=Madras,OU=Sites,OU=iWay,DC=ap,DC=corp','OU',3)+3,6)

you may need to apply other string function if you have other states name here .

Thanks

BKC

Re: Extracting from a big line

Anonymous — Mon, 08 Jun 2015 14:34:40 GMT

PS : the expression is in single line

Re: Extracting from a big line

Anonymous — Mon, 08 Jun 2015 15:21:49 GMT

CN=vk1234,OU=Restricted,OU=Users,OU=ABC,OU=Sites,OU=Norm,DC=mx,DC=net

CN=Tony,OU=Admins,OU=Administration,OU=Norm,DC=ru,DC=org

Hi Michael, I am getting the result for the second line but not for the first line. What might be the Issue. I have the column name as adstate

Re: Extracting from a big line

Anonymous — Mon, 08 Jun 2015 15:27:21 GMT

Works for me, returns ABC... Here is the exact expression:

=TextBetween('CN=vk1234,OU=Restricted,OU=Users,OU=ABC,OU=Sites,OU=Norm,DC=mx,DC=net', 'OU=', ',', 3)