返回
-
标题
How to trim down the SAMaccountName by overrides rule -
说明
The customer is required to synchronic the SAMaccountName from the source to the target. For some users, the SAMAccountName is like this "TW_BA_BC" in the source. But, want to trim down the "TW_" change to "BA_BC" as SAMaccountName to the target -
解决办法
Sample formula for For some users, the SAMAccountName is like this "TW_BA_BC" in the source. But, want to trim down the "TW_" change to "BA_BC" as SAMaccountName to the target.
SUBSTRING(SAMAccountName,LEN(LEFT(SAMAccountName,CHARINDEX('_', SAMAccountName)+1)),LEN(SAMAccountName) - LEN(LEFT(SAMAccountName,CHARINDEX('_', SAMAccountName))))