TextBetween with multiple conditions

[Anonymous]

  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],

[robert_mika]

Not 100% sure but try this:

=TextBetween('

CN=SUPPORT,DC=TOMKINS,DC=NET

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

[alexandros17]

try with

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

[CELAMBARASAN · Accepted solution]

Why could use simply

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

[maxgro]

a different one, maybe

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