topic Re: TextBetween with multiple conditions in QlikView

TextBetween with multiple conditions

Anonymous — Thu, 04 Jun 2015 12:45:30 GMT

COLUMN A

CN=SUPPORT,DC=TOMKINS,DC=NET

CN=Operations Manager ,DC=na,DC=corp

Hi Friends, I need help in using TextBetween.

I have a column as Column A. I would like to extract na alone similarly TOMKINS alone.

I used TextBetween(distinguishedName,'DC=',',DC=corp') and I have got as result. But I have to include the condition in the same script line for extracting TOMKINS. Please help.

I tried the below but TOMKINS is not coming...

If(Index(distinguishedName,'CN'),TextBetween(distinguishedName,'DC=',',DC=corp'),TextBetween(distinguishedName,'DC=',',DC=NET')) as [Domain],

Re: TextBetween with multiple conditions

robert_mika — Thu, 04 Jun 2015 12:57:02 GMT

Not 100% sure but try this:

=TextBetween('

CN=SUPPORT,DC=TOMKINS,DC=NET

CN=Operations Manager ,DC=na,DC=corp','DC=',',DC=')

Re: TextBetween with multiple conditions

alexandros17 — Thu, 04 Jun 2015 12:58:02 GMT

try with

TextBetween(distinguishedName,'DC=',',DC=corp') or TextBetween(distinguishedName,'DC=',',DC=NET')) as [Domain],

Re: TextBetween with multiple conditions

CELAMBARASAN — Thu, 04 Jun 2015 13:10:22 GMT

Why could use simply

=TextBetween(distinguishedName,'DC=',',DC=')

Re: TextBetween with multiple conditions

maxgro — Thu, 04 Jun 2015 16:50:52 GMT

a different one, maybe

=replace(subfield('CN=SUPPORT,DC=TOMKINS,DC=NET', ',', 2), 'DC=', '')