Manipulate output

alancampbell6 · 10-11-2011, 09:02 AM

Code:

"***Search command***" | grep manager | awk '{print $2, $3}'

output:
CN=Bloggs\, Joe,OU=Users,OU=LTMK-E,DC=ad,DC=nexty,DC=com

required output:
Joe Bloggs

Any ideas?

MensaWater · 10-11-2011, 09:20 AM

You can use nested awk statments:

echo CN=Bloggs\, Joe,OU=Users,OU=LTMK-E,DC=ad,DC=nexty,DC=com |awk -F\\ '{print $1,$2}' |awk -F= '{print $2,$3}' |awk -F, '{print $2,$1}' |awk '{print $1" "$2}'

The first awk separates based on the backslash, the second one separates based on the equal sign, the third one separates based on comma and the final one separates on whitespace to remove the space in front of Joe.

tronayne · 10-11-2011, 09:26 AM

It looks like your data file is a CSV (comma-separated-variables)?

What you need to do is get rid of a few things and change the commas to spaces. This is easily done with sed:

Code:

grep manager | sed 's/CN=//;s/\\//;s/,/ /g' | awk '{ print $2 " " $1 }'

ought to do it.

You could fiddle around with AWK, but sed is quicker and easier.

Hope this helps some.

alancampbell6 · 10-11-2011, 09:27 AM

Quote:

Originally Posted by MensaWater

You can use nested awk statments:

echo CN=Bloggs\, Joe,OU=Users,OU=LTMK-E,DC=ad,DC=nexty,DC=com |awk -F\\ '{print $1,$2}' |awk -F= '{print $2,$3}' |awk -F, '{print $2,$1}' |awk '{print $1" "$2}'

The first awk separates based on the backslash, the second one separates based on the equal sign, the third one separates based on comma and the final one separates on whitespace to remove the space in front of Joe.

Thanks MensaWater. Perfect!!!

theNbomr · 10-11-2011, 09:35 AM

Are all entries in the same format, where the 'CN' field has the 'Surname, Firstname' arrangement? If yes, then this might do the trick:

Code:

awk 'BEGIN{FS="[\\\=, ]"}{print $5 " " $2}'

However, this relies on all records having the same consistent format. Without a much larger sample size, no one here can know how to make a fail-proof version.

--- rod.

grail · 10-11-2011, 10:12 AM

@theNbomr - that didn't seem to work for me

Needed an extra back slash and use a different field:

Code:

awk 'BEGIN{FS="[\\\\,= ]+"}/manager/{print $3,$2}'

Threw in 'manager' as grep is a wasted item here.

MensaWater · 10-11-2011, 01:17 PM

Quote:

Originally Posted by alancampbell6

Thanks MensaWater. Perfect!!!

No problem - the sed solution might be a bit more elegant with less impact on your system. I just did the awk as a quick and dirty.