topic Re: Extract Name from Column in Visualization and Usability

Extract Name from Column

Anonymous — Thu, 01 Feb 2018 14:23:32 GMT

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.

Re: Extract Name from Column

m_woolf — Thu, 01 Feb 2018 14:26:41 GMT

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

Re: Extract Name from Column

ali_hijazi — Thu, 01 Feb 2018 14:28:07 GMT

try:

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

Re: Extract Name from Column

vvvvvvizard — Thu, 01 Feb 2018 14:40:21 GMT

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

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

Re: Extract Name from Column

zebhashmi — Thu, 01 Feb 2018 16:31:15 GMT

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'),',',''),'\',' ')

Re: Extract Name from Column

Anonymous — Thu, 01 Feb 2018 19:17:41 GMT

Thank you everyone!