Skip to main content

Is it possible to get the Site from the AD DistinguishedName    : CN=XXXX,OU=XXXX,OU=SITE,OU=XXXX,OU=XXXX,DC=XXXX,DC=XXXX into a Form …CalculatedValue?
I already have the DistinguishedName in the SharePoint UserProfile.

 

Tia!

use formula:

replace(replace(adname, "^CN=[^=]*,OU=[^=]*,OU=", ""), ",OU=.*", "")

text before SITE have to be 'CN=XXXX,OU=XXXX,OU='

text after SITE have to be ',OU=...'


Reply