BASH output format

Question

I would like to format the output from the log file to a single line using BASH:

Log output:

# egrep "^(Infected|Cleaned)" /var/log/scan.log
Infected:          files - 0, objects 0
Cleaned:           files - 0, objects 0

I was able to print the results on one line but I'm not sure how I can format it and remove spaces:

# egrep "^(Infected|Cleaned)" /var/log/scan.log | awk '/Infected/{if (x) print x; x="" } { x = (!x) ? $0 : x "; " $0 } END { print x }'
Infected:          files - 0, objects 0; Cleaned:           files - 0, objects 0

Desired format:

Infected:F-0, O-0; Cleaned:F-0, O-0"

nu11p01n73R · Accepted Answer · 2014-10-15 09:03:32Z

1

Clean

awk '/Infected|Cleaned/{ORS=";"; print $1 "F-"$4 "O-"$6}' inputfile

will produce output

Infected:F-0,O-0;Cleaned:F-0,O-0;

ORS output record seperator is set to ; which seperates the differnt line.

/Infected|Cleaned/ select the lines that match the pattern

EDIT

To add a trailling newline

awk '/Infected|Cleaned/{ORS=";"; print $1 "F-"$4 "O-"$6}END{print "\n"}'

OR

awk '/Infected|Cleaned/{ORS=";"; print $1 "F-"$4 "O-"$6}' sam; echo

edited Oct 15, 2014 at 9:03

answered Oct 15, 2014 at 8:27

nu11p01n73R

26.8k3 gold badges42 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

HTF Over a year ago

Thanks, is there a way to add a trailing new line?

nu11p01n73R Over a year ago

@HTF you are welcome :) to add trailing new line just add a print "\n" in END block. Will edit the answer

bruchowski · Accepted Answer · 2014-10-15 08:22:34Z

1

horribly quick and dirty:

egrep "^(Infected|Cleaned)" /var/log/scan.log | awk '/Infected/{if (x) print x; x="" } { x = (!x) ? $0 : x "; " $0 } END { print x }' | sed 's/\s//g' | sed 's/files/F/g' | sed 's/objects/ O-/g' | sed 's/;/; /g'

answered Oct 15, 2014 at 8:22

bruchowski

5,3617 gold badges33 silver badges46 bronze badges

Comments

fallenland · Accepted Answer · 2014-10-15 08:24:08Z

1

I've piped the output to perl one-liner, this should do it

| perl -ne 's/\s+files\s+\-\s+/ F-/g; s/\s+objects\s+/ O-/g; print'

answered Oct 15, 2014 at 8:24

fallenland

5252 silver badges6 bronze badges

Comments

pjw · Accepted Answer · 2014-10-15 08:29:57Z

1

Try:

awk 'BEGIN { FS = " +"; ORS = " " }; { print $1, "F-", $4, "O-", $6 }' /var/log/scan.log

FS: field separator, set to one or more spaces

ORS: record separator for output, set to a space

With this value of FS, the desired fields are 1, 4, 6; the trailing separators (":", ",", ";", resp.) will be included.

answered Oct 15, 2014 at 8:29

pjw

564 bronze badges

Collectives™ on Stack Overflow

BASH output format

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related