Formatting text output in Bash

Question

I have some output from a pdsh I want to format it to load into a DB. I need it in 3 columns and essentially want the Module ID and the message on one line. Bellow is the output i have:

10.125.45.58,scope, Module ID     = server-1
10.125.45.58,scope, Message       = Correctable memory error
10.125.45.58,scope, Module ID     = server-2
10.125.45.58,scope, Message       = Correctable memory error

This is the output i need:

10.125.45.58,scope,server-1 Correctable memory error
10.125.45.58,scope,server-2 Correctable memory error

I have been awking and seding...i cant work it out any ideas?

Here is what I've done so far

cat myfile.txt | sed -e "s/:/\,scope\,/g" | grep -E '(Module ID|Message)'

Thank you.

Hey, thanks...i dont have any that work or even close, i have already formated the origanl output from the pdsh... # cat myfile.txt | sed -e "s/:/\,scope\,/g" | grep -E '(Module ID|Message)'. — alpha
– alpha, Commented Nov 3, 2016 at 15:23

Sundeep · Accepted Answer · 2016-11-03 15:28:13Z

1

$ cat ip.txt 
10.125.45.58,scope, Module ID     = server-1
10.125.45.58,scope, Message       = Correctable memory error
10.125.45.58,scope, Module ID     = server-2
10.125.45.58,scope, Message       = Correctable memory error 

$ sed 'N; s/\n.*=//; s/ *Module ID.*= *//' ip.txt 
10.125.45.58,scope,server-1 Correctable memory error
10.125.45.58,scope,server-2 Correctable memory error

N get next line, so the substitution works for every two lines considered together
s/\n.*=//; delete from newline character to last =
s/ *Module ID.*= *// then delete everything from Module ID upto = with optional spaces around

answered Nov 3, 2016 at 15:28

Sundeep

23.9k2 gold badges35 silver badges131 bronze badges

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

Comments

Ed Morton · Accepted Answer · 2016-11-03 18:32:10Z

0

sed is for simple substitutions on single lines, that is all. For anything else you should be using awk for portability, efficiency, simplicity, clarity, maintainability, and most other desirable attributes of software:

$ awk 'NR%2{srvr=$NF;next} {ip=$1; sub(/.*=/,""); print ip srvr $0}' file
10.125.45.58,scope,server-1 Correctable memory error
10.125.45.58,scope,server-2 Correctable memory error

answered Nov 3, 2016 at 18:32

Ed Morton

209k18 gold badges90 silver badges212 bronze badges

Collectives™ on Stack Overflow

Formatting text output in Bash

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related