Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try:
replace(replace(textbetween(UserDN,'CN=',',OU='),',',''),'\','')
wrap your subfield expression with replace twice. Once to remove "\" and once to remove ",OU"
try:
replace(replace(textbetween(UserDN,'CN=',',OU='),',',''),'\','')
SubField(Replace( Replace(UserDN,'\',''),'CN=',''),',',1) &','&
SubField(Replace( Replace(UserDN,'\',''),'CN=',''),',',2)
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'),',',''),'\',' ')
Thank you everyone!