I have created a powershell script that displays a column (ServerDN field) that has the following text:
/o=ABC Group/ou=First Administrative Group/cn=Configuration/cn=Servers/cn=LAXMBGroup01/cn=Microsoft Private MDB
/o=ABC Group/ou=First Administrative Group/cn=Configuration/cn=Servers/cn=LAXMBGroup02/cn=Microsoft Private MDB
/o=ABC Group/ou=First Administrative Group/cn=Configuration/cn=Servers/cn=LAXMBGroup03/cn=Microsoft Private MDB
I would like to minimize this column by only displaying LAXMBGroup01, LAXMBGroup01, LAXMBGroup01.
I am thinking the key is to use a parsing command; however, I am not good with reg expressions. I would really appreciate if someone could help me resolve this issue.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.