mwalk
Novice

Extract Regex group

Jump to solution

Hi,

 

im trying to extract a substring from a LDAP query output, but I cant figure out how I can extract just the content of the group.

My pattern looks like this:
`CN=(.*?),OU=*.?Department`

The date im running it on looks like this, there are a few more lines like this with different names and departments:
`CN=Firstname Lastname,OU=Department,OU=Company,DC=Company,DC=local`

 

The data i wish to get is `Firstname Lastname`.

0 Kudos
Reply
2 Replies
Garrett
Communicator

Re: Extract Regex group

Jump to solution

Hi @mwalk 

Here is one possible solution.

 

String (string is without quotes, right?)

`CN=Firstname Lastname,OU=Department,OU=Company,DC=Company,DC=local`

 

Regex - Extract 

(CN=[\w|\s]*),(OU=[\w|\s]*)

Result: 'CN=Firstname Lastname,OU=Department'

 

Regex - Extract 

(CN=[\w|\s]*)

Result: 'CN=Firstname Lastname'

 

If you just wanted 'Firstname Lastname', you need a second Regex to replace the 'CN=' with '' (blank or empty chars) 

 

Cheers

 

Reply
mwalk
Novice

Re: Extract Regex group

Jump to solution
Yes, that works. Thanks a lot!
0 Kudos
Reply