I am trying to extract the first bit of a CN from a Distribution List ManagedBy attribute.  The output is typically something like:

CN=John,OU=OrgUnit,OU=OrgUnit2, etc. . . .

However, the bit between the "CN=" and the first "," is the only thing I want to extract and that bit can vary in length.

I tried using Substring and while I can get the script to start in the third position I haven't yet found a way to tell it to stop when it encounters the first comma.

Anyone found a way to do this?

TIA

Nate

Check out this article I wrote that will get you what you want.

http://blog-powershell.blogspot.com...split.html

Here is the function that the article talks about:

Ok here is what I have so far and it gets me 90+% of the way there.

Get-QADMemberOf $user -indirect| ft Name, @{expression= {$_.ManagedBy.Split(',',2)[0]}}

This gives me the first chunk:

CN=UserName

and chucks the rest.

I tried using Replace before, inline and after, but no go there. 

Back to the drawing board to bang my head for a while.

Hmm.  No need to bang your head.  Not sure why you didn't try my suggestion.  It is exactly what you need.

Maybe this will help:


If you don't like that then try this:


The link to my post earlier explained how the -Split works.  -split will use [regex] as delimiters.

Your first solution did work (once I got took my blinders off).  So did your second for that matter.

I will need to work at understanding why the REGEX stuff works, but that is for another day as my work day is ending.

My humble thanks for your patience and assistance.

Nate

No problem bro. Glad you got it working.