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.
Solved! Go to Solution.
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'),',',''),'\',' ')