Extract Name from Column

[Anonymous]

Hi, I have a dimension called UserDN that has full user names in the column. I am trying to get the user name extracted out into a separate column so it looks like the mock up below. I have used the subfield expression but it comes out as "Smith\,John,OU". Any suggestions would be appreciated.

[m_woolf]

wrap your subfield expression with replace twice. Once to remove "\" and once to remove ",OU"

[ali_hijazi · Accepted solution]

try:

replace(replace(textbetween(UserDN,'CN=',',OU='),',',''),'\','')

[vvvvvvizard]

SubField(Replace( Replace(UserDN,'\',''),'CN=',''),',',1)  &','&

SubField(Replace( Replace(UserDN,'\',''),'CN=',''),',',2)

[zebhashmi]

SubField(Replace(left(UserDN,3),""&Replace(Right(UserDN,25),""&Replace('\,',' ')

or may be this

SubField(Replace(Replace(left(Replace(Right(UserDN,25),' ')),3),' '),'\',' ')

looks like Ali's would work fine just add

replace(replace(textbetween(UserDN,'CN=',',OU=term and contractors'),',',''),'\',' ')

[Anonymous]

Thank you everyone!