cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Delimiter

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!

Labels: (2)
0 Kudos
Reply
1 Reply
Workflow Hero

Re: Delimiter

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=...'

0 Kudos
Accept as Solution Reply