Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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],
Not 100% sure but try this:
=TextBetween('
CN=SUPPORT,DC=TOMKINS,DC=NET
CN=Operations Manager ,DC=na,DC=corp','DC=',',DC=')
try with
TextBetween(distinguishedName,'DC=',',DC=corp') or TextBetween(distinguishedName,'DC=',',DC=NET')) as [Domain],
Why could use simply
=TextBetween(distinguishedName,'DC=',',DC=')
a different one, maybe
=replace(subfield('CN=SUPPORT,DC=TOMKINS,DC=NET', ',', 2), 'DC=', '')