extract names from LDAP long names
Clash Royale CLAN TAG#URR8PPP
up vote
5
down vote
favorite
I have this log file which observe user actions on the network, the file contain information from LDAP, very long list like this one:
2015-12-02 10:55:32Z cn=jsmith,ou=sales,dc=company,dc=com
2015-12-02 10:55:54Z cn=bjones,ou=sales,dc=company,dc=com
I want to extract just the cn names :
jsmith
bjones
how can I do it?
sed
edited 7 hours ago
msp9011
3,65043862
asked 7 hours ago
Cadice
283
New contributor
Cadice is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |Â
up vote
5
down vote
favorite
I have this log file which observe user actions on the network, the file contain information from LDAP, very long list like this one:
2015-12-02 10:55:32Z cn=jsmith,ou=sales,dc=company,dc=com
2015-12-02 10:55:54Z cn=bjones,ou=sales,dc=company,dc=com
I want to extract just the cn names :
jsmith
bjones
how can I do it?
sed
edited 7 hours ago
msp9011
3,65043862
asked 7 hours ago
Cadice
283
New contributor
Cadice is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |Â
up vote
5
down vote
favorite
up vote
5
down vote
favorite
I have this log file which observe user actions on the network, the file contain information from LDAP, very long list like this one:
2015-12-02 10:55:32Z cn=jsmith,ou=sales,dc=company,dc=com
2015-12-02 10:55:54Z cn=bjones,ou=sales,dc=company,dc=com
I want to extract just the cn names :
jsmith
bjones
how can I do it?
sed
edited 7 hours ago
msp9011
3,65043862
asked 7 hours ago
Cadice
283
New contributor
Cadice is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have this log file which observe user actions on the network, the file contain information from LDAP, very long list like this one:
2015-12-02 10:55:32Z cn=jsmith,ou=sales,dc=company,dc=com
2015-12-02 10:55:54Z cn=bjones,ou=sales,dc=company,dc=com
I want to extract just the cn names :
jsmith
bjones
how can I do it?
sed
sed
edited 7 hours ago
msp9011
3,65043862
asked 7 hours ago
Cadice
283
New contributor
Cadice is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 7 hours ago
msp9011
3,65043862
asked 7 hours ago
Cadice
283
New contributor
Cadice is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 7 hours ago
msp9011
3,65043862
edited 7 hours ago
msp9011
3,65043862
edited 7 hours ago
msp9011
3,65043862
3,65043862
asked 7 hours ago
Cadice
283
New contributor
Cadice is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 7 hours ago
Cadice
283
asked 7 hours ago
Cadice
283
283
New contributor
Cadice is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Cadice is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Cadice is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |Â
add a comment |Â
3 Answers
3
active
oldest
votes
up vote
5
down vote
accepted
can be done with sed:
sed 's/^.*cn=([^,]*).*$/1/' file
jsmith
bjones
or grep
grep -oP '(?<=cn=)[^, ]+' file
or perl
perl -lne '/cn=(w*),/ && print $1' file
or cut & tr
cut -d'=' -f2 file | tr -d 'ou,'
answered 7 hours ago
Goro
8,13753978
add a comment |Â
up vote
3
down vote
using sed:
sed -e 's/.*cn=(.*),ou.*/1/' file
using awk
awk -F '[=,]' 'print $2' file
or
awk -F 'cn=|,' 'print $2' file
answered 7 hours ago
msp9011
3,65043862
add a comment |Â
up vote
3
down vote
% < input
2015-12-02 10:55:32Z cn=jsmith,ou=sales,dc=company,dc=com
2015-12-02 10:55:54Z cn=bjones,ou=sales,dc=company,dc=com
% perl -nle 'print $1 if m/ cn=([^,]+)/' input
jsmith
bjones
on the assumptions that a comma will not appear in the record name and that cn= do not appear elsewhere in the log
answered 7 hours ago
thrig
23k12854
add a comment |Â
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
5
down vote
accepted
can be done with sed:
sed 's/^.*cn=([^,]*).*$/1/' file
jsmith
bjones
or grep
grep -oP '(?<=cn=)[^, ]+' file
or perl
perl -lne '/cn=(w*),/ && print $1' file
or cut & tr
cut -d'=' -f2 file | tr -d 'ou,'
answered 7 hours ago
Goro
8,13753978
add a comment |Â
up vote
5
down vote
accepted
can be done with sed:
sed 's/^.*cn=([^,]*).*$/1/' file
jsmith
bjones
or grep
grep -oP '(?<=cn=)[^, ]+' file
or perl
perl -lne '/cn=(w*),/ && print $1' file
or cut & tr
cut -d'=' -f2 file | tr -d 'ou,'
answered 7 hours ago
Goro
8,13753978
add a comment |Â
up vote
5
down vote
accepted
up vote
5
down vote
accepted
can be done with sed:
sed 's/^.*cn=([^,]*).*$/1/' file
jsmith
bjones
or grep
grep -oP '(?<=cn=)[^, ]+' file
or perl
perl -lne '/cn=(w*),/ && print $1' file
or cut & tr
cut -d'=' -f2 file | tr -d 'ou,'
answered 7 hours ago
Goro
8,13753978
can be done with sed:
sed 's/^.*cn=([^,]*).*$/1/' file
jsmith
bjones
or grep
grep -oP '(?<=cn=)[^, ]+' file
or perl
perl -lne '/cn=(w*),/ && print $1' file
or cut & tr
cut -d'=' -f2 file | tr -d 'ou,'
answered 7 hours ago
Goro
8,13753978
edited 7 hours ago
answered 7 hours ago
Goro
8,13753978
answered 7 hours ago
Goro
8,13753978
answered 7 hours ago
Goro
8,13753978
8,13753978
add a comment |Â
add a comment |Â
up vote
3
down vote
using sed:
sed -e 's/.*cn=(.*),ou.*/1/' file
using awk
awk -F '[=,]' 'print $2' file
or
awk -F 'cn=|,' 'print $2' file
answered 7 hours ago
msp9011
3,65043862
add a comment |Â
up vote
3
down vote
using sed:
sed -e 's/.*cn=(.*),ou.*/1/' file
using awk
awk -F '[=,]' 'print $2' file
or
awk -F 'cn=|,' 'print $2' file
answered 7 hours ago
msp9011
3,65043862
add a comment |Â
up vote
3
down vote
up vote
3
down vote
using sed:
sed -e 's/.*cn=(.*),ou.*/1/' file
using awk
awk -F '[=,]' 'print $2' file
or
awk -F 'cn=|,' 'print $2' file
answered 7 hours ago
msp9011
3,65043862
using sed:
sed -e 's/.*cn=(.*),ou.*/1/' file
using awk
awk -F '[=,]' 'print $2' file
or
awk -F 'cn=|,' 'print $2' file
answered 7 hours ago
msp9011
3,65043862
answered 7 hours ago
msp9011
3,65043862
answered 7 hours ago
msp9011
3,65043862
answered 7 hours ago
msp9011
3,65043862
3,65043862
add a comment |Â
add a comment |Â
up vote
3
down vote
% < input
2015-12-02 10:55:32Z cn=jsmith,ou=sales,dc=company,dc=com
2015-12-02 10:55:54Z cn=bjones,ou=sales,dc=company,dc=com
% perl -nle 'print $1 if m/ cn=([^,]+)/' input
jsmith
bjones
on the assumptions that a comma will not appear in the record name and that cn= do not appear elsewhere in the log
answered 7 hours ago
thrig
23k12854
add a comment |Â
up vote
3
down vote
% < input
2015-12-02 10:55:32Z cn=jsmith,ou=sales,dc=company,dc=com
2015-12-02 10:55:54Z cn=bjones,ou=sales,dc=company,dc=com
% perl -nle 'print $1 if m/ cn=([^,]+)/' input
jsmith
bjones
on the assumptions that a comma will not appear in the record name and that cn= do not appear elsewhere in the log
answered 7 hours ago
thrig
23k12854
add a comment |Â
up vote
3
down vote
up vote
3
down vote
% < input
2015-12-02 10:55:32Z cn=jsmith,ou=sales,dc=company,dc=com
2015-12-02 10:55:54Z cn=bjones,ou=sales,dc=company,dc=com
% perl -nle 'print $1 if m/ cn=([^,]+)/' input
jsmith
bjones
on the assumptions that a comma will not appear in the record name and that cn= do not appear elsewhere in the log
answered 7 hours ago
thrig
23k12854
% < input
2015-12-02 10:55:32Z cn=jsmith,ou=sales,dc=company,dc=com
2015-12-02 10:55:54Z cn=bjones,ou=sales,dc=company,dc=com
% perl -nle 'print $1 if m/ cn=([^,]+)/' input
jsmith
bjones
on the assumptions that a comma will not appear in the record name and that cn= do not appear elsewhere in the log
answered 7 hours ago
thrig
23k12854
answered 7 hours ago
thrig
23k12854
answered 7 hours ago
thrig
23k12854
answered 7 hours ago
thrig
23k12854
23k12854
add a comment |Â
add a comment |Â
Cadice is a new contributor. Be nice, and check out our Code of Conduct.
Â
draft saved
draft discarded
Cadice is a new contributor. Be nice, and check out our Code of Conduct.
Cadice is a new contributor. Be nice, and check out our Code of Conduct.
Cadice is a new contributor. Be nice, and check out our Code of Conduct.
Â
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f474337%2fextract-names-from-ldap-long-names%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
