Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Print vertical to horizontal

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Print vertical to horizontal
# 1  
Old 04-15-2015
Print vertical to horizontal
Hi Masters,
I need help to change my vertical data to horisontal

input
Code:
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
Code:
date|JS|JSJ|JSD|JM|JMD|JMJ
2015-04-12|0|0|0|0|0|1|0
2015-04-13|1|1|1|0|2|0|0
2015-04-14|0|0|1|0|0|0|1

I did this
Code:
 awk -F"|" '{if($2 ~ /JS/ || $2 ~ /JSJ/ || $2 ~ /JSD/ || $2 ~ /JM/ || $2 ~ /JMD/ || $2 ~ /JMJ/){A=A?A OFS $0:$0}} END{print A}' OFS=, input

Need help please
# 2  
Old 04-15-2015
I can't produce the output you said you want because I don't know which field you added to the output lines (except the header line). Your data output lines have 8 fields; you header output line has seven fields. To produce data that seems to correspond to what you were trying to do with data based on the header line you said you wanted in post #1, you could try something like:
Code:
awk '
BEGIN { FS = OFS = "|"
        headers="date|JS|JSJ|JSD|JM|JMD|JMJ"
        print headers
        nh = split(headers, h)
        for(i = 1; i <= nh; i++)
                t[h[i]] = i
}
$2 in t {
        data[d[$1] = $1, t[$2]]++ 
}
END {   for(i in d) {
                printf("%s", i)
                for(j = 2; j <= nh; j++)
                        printf("%s%d", OFS, data[i, j])
                print ""
        }
}' input | sort -n -t- -k1,3

which, with your sample input file, produces the output:
Code:
date|JS|JSJ|JSD|JM|JMD|JMJ
2015-04-12|0|0|0|0|1|0
2015-04-13|1|1|0|2|0|0
2015-04-14|0|0|1|0|0|1

If you want to try this on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk.
# 3  
Old 04-15-2015
This may do what you want (you'll need to modify the output if you insist on pipe delimiters):
Code:
awk     '       {LN[$1]; HD[$2]; MX[$1,$2]++}
         END    {               printf "%10s", ""; for (i in HD) printf "%10s", i; print "";
                 for (j in LN) {printf "%10s",j;   for (i in HD) printf "%10s", MX[j,i]+0; print ""}
                }
        ' FS="|" file
                  TM       JMD       JMJ       JSD       TMS       JSJ        JM        JS
2015-04-12         0         1         0         0         0         0         0         0
2015-04-13         1         0         0         0         1         1         2         1
2015-04-14         0         0         1         1         0         0         0         0

 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need to move vertical to horizontal using paste

Source file Name:hostname1 Masking views : Yes Storage Group Names : hostname1 device (5): Name:hostname2 Masking views : Yes Storage Group Names : hostname2 device (5): Name:hostname3 Masking views : no Storage Group Names : hostname3 device (5):... (9 Replies)
Discussion started by: ranjancom2000
9 Replies

2. Shell Programming and Scripting

Transform vertical into horizontal list

Hi, I am creating a script that will pull data from database. The only thing missing now is that i have to transform the lines into horizontal list. EXAMPLE 2015-07-15 09:00:00.0 |TCSERVER01 |5354 2015-07-15 09:01:00.0 |TCSERVER01 |6899 ... (5 Replies)
Discussion started by: reignangel2003
5 Replies

3. 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

4. Shell Programming and Scripting

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 empname robert empid 787 design consultant empname alex empid 898 design advocate Desired output should be empname empid design robert 787 consultant (19 Replies)
Discussion started by: rocky2013
19 Replies

5. 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

6. 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

7. Shell Programming and Scripting

awk Help: Horizontal to Vertical print with pattern match

Hi AWK Experts, Following is the data : BRH113 DD AA HH CA DD DD AA HH BRH091 A4 A6 AH H7 67 HH J8 9J BRH0991 AA D8 C23 V5 H7 BR2 BRH991 AA HH GG5 BT0 JJ0 I want the output to be alligned with the pattern matching "BRH" inthe line. The output should be look like: A]... (4 Replies)
Discussion started by: rveri
4 Replies

8. 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

9. 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

10. 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
Login or Register to Ask a Question