Re: Manager Field from LDAP (173 Views)
Reply
Super Advisor
Posts: 362
Registered: ‎06-13-2009
Message 1 of 3 (210 Views)

Manager Field from LDAP

Hi all,
I developed a connect it scenario that retrieves LDAP users with details to SM using ldap connector and SM web services connector but the problem is that the manager field is populated from AD to SM with all path like this one
CN=Administrator,CN=Users,DC=xxx,DC=xxx,DC=xxx
see attached image.
so is there any way to parse this from connect it so i can only populate the user name of manager only ?
Frequent Advisor
Posts: 65
Registered: ‎01-05-2012
Message 2 of 3 (180 Views)

Re: Manager Field from LDAP

RetVal=UCase(RightPart(LeftPart([manager],",OU=",0,"CN=",0))

Frequent Advisor
Posts: 65
Registered: ‎01-05-2012
Message 3 of 3 (173 Views)

Re: Manager Field from LDAP

RetVal=UCase((RightPart(LeftPart((Replace([manager],"\","")),",OU=",0,"CN=",0)))

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.