Change the vertical logs to horizontal line

12-12-2013

Registered User

90, 1

Join Date: Dec 2008

Last Activity: 6 March 2018, 1:41 AM EST

Posts: 90

Thanks Given: 15

Thanked 1 Time in 1 Post

Change the vertical logs to horizontal line

Hi,

cat log

Code:

EPC-SubsId: 3333
EPC-GrIds: RTGHUPA:1:15-11-2013T19:59,22-11-2013T19:59
EPC-GrIds: PrimaXGB_23:10

EPC-SubsId: 4444
EPC-GrIds: RTGHUPB:1:15-11-2013T19:59,22-11-2013T19:59

EPC-SubId: 5555
EPC-GrIds: RTGHUPC:1:15-11-2013T19:59,22-11-2013T19:59

EPC-SubsId: 6666
EPC-GrIds: RTGHUPD:1:15-11-2013T19:59,22-11-2013T19:59
EPC-GrIds: 4PrimaSGB_23:10

I want the results become :

Code:

3333 RTGHUPA:1:15-11-2013T19:59,22-11-2013T19:59 PrimaXGB_23:10
4444 RTGHUPB:1:15-11-2013T19:59,22-11-2013T19:59 
5555 RTGHUPC:1:15-11-2013T19:59,22-11-2013T19:59 
6666 RTGHUPD:1:15-11-2013T19:59,22-11-2013T19:59 4PrimaSGB_23:10

Anybody can help ?

Thanks.

justbow

View Public Profile for justbow

Find all posts by justbow

12-12-2013

Moderator

1,837, 668

Join Date: Nov 2012

Last Activity: 30 June 2020, 12:07 PM EDT

Posts: 1,837

Thanks Given: 180

Thanked 668 Times in 590 Posts

Code:

$ awk '{printf NF ? $2 OFS : RS}END{printf RS}' file

Code:

3333 RTGHUPA:1:15-11-2013T19:59,22-11-2013T19:59 PrimaXGB_23:10 
4444 RTGHUPB:1:15-11-2013T19:59,22-11-2013T19:59 
5555 RTGHUPC:1:15-11-2013T19:59,22-11-2013T19:59 
6666 RTGHUPD:1:15-11-2013T19:59,22-11-2013T19:59 4PrimaSGB_23:10

--edit---

if your log file contains multiple blank line then use this one

Code:

$ awk '{printf (NR > 1 && /EPC-Sub/) ? RS $2 OFS : $2 OFS }END{printf RS} ' file

Last edited by Akshay Hegde; 12-12-2013 at 03:52 AM.. Reason: simplification

Akshay Hegde

View Public Profile for Akshay Hegde

Find all posts by Akshay Hegde

Shell Programming and Scripting

Change the vertical logs to horizontal line

10 More Discussions You Might Find Interesting

1. Emergency UNIX and Linux Support

Help parsing log from vertical to horizontal line

Discussion started by: justbow

2. UNIX for Dummies Questions & Answers

Change Vertical to Horizontal

Discussion started by: radius

3. Shell Programming and Scripting

How do i do the vertical to horizontal??

Discussion started by: nikhil jain

4. Shell Programming and Scripting

Need perl or shell script to sort vertical lines to horizontal line in csv format

Discussion started by: sreedhargouda.h

5. Shell Programming and Scripting

change log vertical to horizontal lines

Discussion started by: justbow

6. UNIX for Dummies Questions & Answers

How to move vertical line to Horizontal...

Discussion started by: Arsh10

7. UNIX for Dummies Questions & Answers

Horizontal to vertical

Discussion started by: Xterra

8. Shell Programming and Scripting

Need help in changing vertical lines to horizontal line in a file

Discussion started by: rocky1954

9. Shell Programming and Scripting

Draw a Horizontal and Vertical line on UNIX

Discussion started by: allways4u21

10. UNIX for Dummies Questions & Answers

converting horizontal line to vertical line

Discussion started by: vasikaran