Hi everyone,

Could someone help me to print this info? I tried some awk but it was not printing well.

I used this awk statement with different trials but it was not printing it right.

awk '
/^dn:/ { dn = $0 }
/ou=test1|usergroup=cust1/ { print dn;}' input > output




input file:

dn: uid=user1, ou=test1,o=test.com
usergroup: cust1

dn: uid=user2, ou=test1,o=test.com
usergroup: cust1

dn: uid=user3, ou=test1,o=test.com
usergroup: cust1

dn: uid=user4, ou=test1,o=test.com
usergroup: abc1

dn: uid=user4, ou=test1,o=test.com
usergroup: abc1

.
.
.

desired: to print users having "ou=test1 and usergroup: cust1"

output:

user1
user2




Thanks

perl -ne '($user,$ou) = /.*uid=(.*?), ou=(.*?),.*/ if /^dn/; print "$user\n" if /^usergroup: cust1/ && $ou eq "test1";' /tmp/input.txt

I appreciate for the great liner code but one more thing can you check please? How to define ou in the line? It can be different in a large file over 15GB.

Thanks again

pleae ignore it...it is working...thanks a lot...

If I wanted to negate an attribute in perl, how can I do it?

For example, if I want to filter out "ou=est1" and "ou=test2" and print any other uid's having usergroup: cust1

Please let me know your opinion...Thanks again...


perl -ne '($user,$ou) = /.*uid=(.*?), ou=(.*?),.*/ if /^dn/; print "$user\n" if /^usergroup: cust1/ && $ou eq "test1";' /tmp/input.txt

use ne instead of eq or put a ! in front of the expression !(...)

... && ($ou ne "test1") && ($ou ne "test2") ...

awk -F " |=" 'BEGIN{RS="dn"}$5~/test1/&&$NF~/cust1/{print $3}' urfile | sed 's/,$//'