UNIX cumulater


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting UNIX cumulater
# 1  
Old 07-09-2013
UNIX cumulater

hi all

i want a script to get a cumulative item , data as following
Code:
realM,spain,win,night -----1
barca,spain,win,night  
realM,spain,lose,night ----2
realM,spain,win,night------3
realM,spain,lose,night -----4
realM,spain,lose,night-------5
barca,spain,lose,night
barca,spain,win,night
realM,spain,win,night-------6

to get output as
Code:
barca,spain,2win,1lose,night
realM,spain,3lose,3win,night

thanks a lot

i think its the same concept on uniq -c but in awk

Last edited by radoulov; 07-09-2013 at 08:12 AM..
# 2  
Old 07-09-2013
try..

Code:
 
awk -F, '{if($3=="win"){A[$1","$2]++}else{B[$1","$2]++}}END{for(i in A){print i","A[i]"win,"B[i]"lose"}}' filename

This User Gave Thanks to vidyadhar85 For This Post:
# 3  
Old 07-09-2013
thanks alot,sorry, if i need the output as the following
Code:
barca,spain,2win,night     ---- 2 win and 1 lose  ----- drop lose 
realM,spain,3win,night

here we got the ($3) that counted more and if equal get the first one .

Code:
sorry if i dont know what comes in $3 as if its serial code

Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Post Here to Contact Site Administrators and Moderators

VIP Membership - The UNIX and Linux Forums - Get Your UNIX.COM Email Address Here

We work hard to make The UNIX and Linux Forums one of the best UNIX and Linux knowledge sources on the net. The site is certainly one of the top UNIX and Linux Q&A sites on the web. In order to provide certain members the best quality account services, you can now get some great extra features by... (2 Replies)
Discussion started by: Neo
2 Replies

2. Shell Programming and Scripting

UNIX cumulater

hi all i want a script to get a cumulative item , data as following realM,spain,win,night -----1 barca,spain,win,night realM,spain,lose,night ----2 realM,spain,win,night------3 realM,spain,lose,night -----4 realM,spain,lose,night-------5 barca,spain,lose,night barca,spain,win,night... (0 Replies)
Discussion started by: teefa
0 Replies

3. Shell Programming and Scripting

File Transfer from Window server to UNIX and UNIX to UNIX

Dear All, Can someone help to command or program to transfer the file from windows to Unix server and from one unix server to another Unix server in secure way. I would request no samba client. (4 Replies)
Discussion started by: yadavricky
4 Replies

4. UNIX for Dummies Questions & Answers

How does unix system administration, unix programming, unix network programming differ?

How does unix system administration, unix programming, unix network programming differ? Please help. (0 Replies)
Discussion started by: thulasidharan2k
0 Replies

5. Shell Programming and Scripting

Batch job in unix server to move the pdf file from unix to windows.

Hi Experts, I have a requirement where i need to setup a batch job which runs everymonth and move the pdf files from unix server to windows servers. Could some body provide the inputs for this. and also please provide the inputs on how to map the network dirve in the unix like that... (1 Reply)
Discussion started by: ger199901
1 Replies

6. Shell Programming and Scripting

FTP script for sending a file from one unix directory to another unix server director

Hi, My local server is :/usr/abcd/ Remote server is :/Usr/host/test/ I want to send files from local unix directory(All files starting with O_999) to remote host unix directory. Can any body give me the Unix Shell script to do this. One more doubt: Shall we need to change the file... (1 Reply)
Discussion started by: raja_1234
1 Replies

7. UNIX for Advanced & Expert Users

missing Path(in UNIX) when i launch a job on to unix machine using windows SSh

hi i want run an unix application from a windows program/application.i am using SSH(command line version)to log on to a unix machine from windows. the application has to read a configuration file inorder to run. the configuration file .CFG is in bin in my home directory. but the application... (1 Reply)
Discussion started by: megastar
1 Replies

8. UNIX for Dummies Questions & Answers

UNIX problem? Unix programm runs windows 2000 CPU over 100%

Okee problems...!! What is happening: Unix server with some programms, workstations are windows 2000, the workstations work good but when you start a programm on the Unix server the CPU of the workstations go to 100% usage resulting that the system gets very slow. The programm well its running so... (2 Replies)
Discussion started by: zerocool
2 Replies
Login or Register to Ask a Question