Change the vertical logs to horizontal line Post: 302879346

Sponsored Content

Top Forums Shell Programming and Scripting Change the vertical logs to horizontal line Post 302879346 by Akshay Hegde on Thursday 12th of December 2013 02:07:51 AM

12-12-2013

Moderator

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

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

converting horizontal line to vertical line

how to use "tr" command to display horizontal line to vertical line for vertical to horizontal, the command is tr '\n' '\t' <inputfile but what is the command for horizontal to vertical Thanks Vasikaran

2. Shell Programming and Scripting

Draw a Horizontal and Vertical line on UNIX

I want to draw a horizontal and vertical line on Unix. Please suggest some solution.

3. Shell Programming and Scripting

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

Hi, I have a file like below robert PREF: 3 AVAIL: henry PREF: 234 AVAIL: john PREF: 145,178 AVAIL: 123 matt PREF: 564,932 AVAIL: ten PREF: 389 AVAIL: kill

4. UNIX for Dummies Questions & Answers

Horizontal to vertical

Hi, Silly question, if I have an excel file that looks something like this: ................. Subject 1 Subject 2 Subject 3 Subject 4 Fever..............13...........9.............23..........14 Headache.........2............12...........18..........23...

5. UNIX for Dummies Questions & Answers

How to move vertical line to Horizontal...

How to move a vertical line to Horizontal line.....Can i use a tr command? code is: StudentID Java .Net C# I want to move this line like this: StudentID Java .Net C# Please use code tags!

6. Shell Programming and Scripting

change log vertical to horizontal lines

Hi, Need help unix command to change this : become this Anyone can help me?:wall:

7. Shell Programming and Scripting

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

Need perl or shell script to sort vertical lines to horizontal line in csv format My file like below ------------------------- ================================================================================ PATH PINKY1000#I1-1-ZENTA1000-2#I7-1-ASON-SBR-UP-943113845 ...

8. Shell Programming and Scripting

How do i do the vertical to horizontal??

51009 8746 8912 17986 20315 24998 5368 38934 7805 8566

9. UNIX for Dummies Questions & Answers

Change Vertical to Horizontal

10. Emergency UNIX and Linux Support

Help parsing log from vertical to horizontal line

Hi Expert, i have log in attached (log.txt) i want the log result become horizontal line : recordOpeningTime,servedMSISDN,ratingGroup,datavolumeFBCUplink,datavolumeFBCDownlink 1502260153422B0800,196738930571,3,7946,2219 1502260153422B0800,196738930571,3,233,174...

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

converting horizontal line to vertical line

Discussion started by: vasikaran

2. Shell Programming and Scripting

Draw a Horizontal and Vertical line on UNIX

Discussion started by: allways4u21

3. Shell Programming and Scripting

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

Discussion started by: rocky1954

4. UNIX for Dummies Questions & Answers

Horizontal to vertical

Discussion started by: Xterra

5. UNIX for Dummies Questions & Answers

How to move vertical line to Horizontal...

Discussion started by: Arsh10

6. Shell Programming and Scripting

change log vertical to horizontal lines

Discussion started by: justbow

7. Shell Programming and Scripting

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

Discussion started by: sreedhargouda.h

8. Shell Programming and Scripting

How do i do the vertical to horizontal??

Discussion started by: nikhil jain

9. UNIX for Dummies Questions & Answers

Change Vertical to Horizontal

Discussion started by: radius

10. Emergency UNIX and Linux Support

Help parsing log from vertical to horizontal line

Discussion started by: justbow