Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Help! output format from vertical to horizontal

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help! output format from vertical to horizontal
# 1  
Old 08-09-2013
Help! output format from vertical to horizontal
Hi All,

please help to achieve the desired output
Example: I have a file which contains the below data
Code:
empname
robert
empid
787
design
consultant
empname
alex
empid
898
design
advocate

Desired output should be
Code:
empname empid design
robert 787 consultant
alex 898 advocate

I have achieved the below output with the command but this is not my requirement.

Code:
 paste -d '  '  - - < inputfile > outputfile

Code:
empname robert
empid 787
design consultant
empname alex
empid 898
design advocate

Kindly help me to achieve the desired output as shown above

Thanks in advance.
Last edited by Scott; 08-09-2013 at 10:13 AM.. Reason: Please use code tags for code and data
# 2  
Old 08-09-2013
Code:
xargs -n6 < file | awk '
        NR == 1 {
                for ( i = 1; i <= NF; i+=2 )
                        printf "%s\t", $i
                printf "\n"
        }
        {
                for ( i = 2; i <= NF; i+=2 )
                        printf "%s\t", $i
                printf "\n"
        }
'

# 3  
Old 08-09-2013
Simple approach
Code:
awk 'BEGIN {print "empname empid design"} /empname/ {getline;printf "%s ",$0;getline;getline;printf "%s ",$0;getline;getline;print}'

# 4  
Old 08-09-2013
Thanks a lot Jotne and Yoda for excellent commands.
# 5  
Old 08-09-2013
Some more variation
Code:
awk 'BEGIN {print "empname empid design"} /empname/{a=NR} NR==a+1||NR==a+3{printf "%s ",$0} NR==a+5' file

# 6  
Old 08-09-2013
Quote:
Posted by Jotne:
Simple approach


Code:
awk 'BEGIN {print "empname empid design"} /empname/ {getline;printf "%s ",$0;getline;getline;printf "%s ",$0;getline;getline;print}'
Could you please let me know why at the last
Code:
 printf

is not used here? Also is this
Code:
 %s

is used for formatting?

Will be grateful to you for same.

Thanks,
R. Singh
# 7  
Old 08-09-2013
The GNU Awk User's Guide: Printing
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Print vertical to horizontal

Hi Masters, I need help to change my vertical data to horisontal input 2015-04-13|JS|741667 2015-04-13|JSJ|2272 2015-04-13|TMS|107099 2015-04-12|JMD|47945 2015-04-13|TM|760024 2015-04-13|JM|484508 2015-04-14|JMJ|318 2015-04-14|JSD|54436 2015-04-13|JM|15410 Output... (2 Replies)
Discussion started by: radius
2 Replies

2. UNIX for Dummies Questions & Answers

Change Vertical to Horizontal

I need to change data from vertical to horizontal but with condition input USA|80 AUS|40 BRA|33 VEGAS|40 KENTUCKY|50 NEWYORK|21 DARWIN|33 ADELAIDE|21 SAOPAOLO|44 RIO|89 GAPIZA|44 BENFLEX|32 AXIS|44 ACRE|56 HEIGHT|22 (5 Replies)
Discussion started by: radius
5 Replies

3. Shell Programming and Scripting

How do i do the vertical to horizontal??

51009 8746 8912 17986 20315 24998 5368 38934 7805 8566 (4 Replies)
Discussion started by: nikhil jain
4 Replies

4. Shell Programming and Scripting

awk in horizontal and vertical math

Based on input ail,UTT,id1_0,COMBO,21,24,21,19,85 al,UTHAST,id1_0,COMBO,342,390,361,361,1454 and awk code as awk -F, '{ K=0; for(i=NF; i>=(NF-4); i--) { K=K+$i; J=J+$i;} { print K } } END { for ( l in J ) printf("%s ",J); }' I'm trying to add columns and lines in single line. line... (6 Replies)
Discussion started by: busyboy
6 Replies

5. 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 ... (4 Replies)
Discussion started by: sreedhargouda.h
4 Replies

6. Shell Programming and Scripting

Vertical And Horizontal Pivoting

Hi All, My Input data is: A=1 B=2 My desired Output should be: A|B 1|2 Thanks in advance... (3 Replies)
Discussion started by: kmsekhar
3 Replies

7. UNIX for Dummies Questions & Answers

vertical to horizontal

dear all, i'm new to unix and i try to figure out the best case for making list of vertical text to become horizontal and skip the line 1 and 2. example text : Data DATE XXXXX MAX 47 53 49 51 48 48 7 46 51 8 25 (6 Replies)
Discussion started by: andrisetia
6 Replies

8. 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... (3 Replies)
Discussion started by: Xterra
3 Replies

9. Shell Programming and Scripting

Formatting isql output to horizontal format

Hi I am formatting informix isql output(vertical) to horizontal format. Suppose I have the following content in the flat file from isql output - item_nbr 0 usfn_label Subscriber Class usfn_name SBCLASS usfn_value bl5 item_nbr 1 usfn_label Switch Name usfn_name switchName... (2 Replies)
Discussion started by: nsinha
2 Replies

10. Shell Programming and Scripting

combine files in horizontal way, not vertical.

Hi Everyone, I have three files. FileA: aaaa aaaa bb ccc FileB: 21 2 FileC: eeeeeee e eee ee Would like to combine three of them, not like cat, to cat three files, but the output should be like: (3 Replies)
Discussion started by: jimmy_y
3 Replies
Login or Register to Ask a Question