https://www.infopathdev.com:443/forums/57.aspxQdabra Active Directory Web Service enables showing all Microsoft Active Directory user details in InfoPath forms. It is available in Database Accelerator, WSSP and as a standalone tool.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/18975.aspxThu, 22 Mar 2007 17:03:02 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:18975Matt Faus0https://www.infopathdev.com:443/forums/thread/18975.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=57&PostID=18975Hey quikdoc,<br /><br />You can do this in rules or code with a substring operation. It would look something like this:<br /><br />substring( indexOf("CN="), indexOf(",OU") - indexOf("CN=") )https://www.infopathdev.com:443/forums/thread/18925.aspxFri, 02 Feb 2007 14:39:45 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:18925quikdoc0https://www.infopathdev.com:443/forums/thread/18925.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=57&PostID=18925I like the webservice, real easy to set up and use. The only problem I am having is I can get the manager info I gerythet the Cn, ou and everything else. Is there a way to pull just the CN portion of the manager information.<br />What I am getting?<br />(Example:manager CN=testgp,OU=IT Department,DC=crmc,DC=com)<br /><br />What I need?<br />(Example: testgp)<br /><br />Any help would be appreciated.<br /><br />Thanks