Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

need to get consolidated result from logs

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting need to get consolidated result from logs
# 1  
Old 02-24-2009
need to get consolidated result from logs
already have a file with below details

request 1 | 2
request 2 | 3
request 1 | 4
request 2 | 5


result required in third file


request 1 | 6
request 2 | 8
# 2  
Old 02-24-2009
Code:
awk -F"|" '{_[$1]+=$2} END{for (a in _) {print a"|" _[a]}}' infile
request 1 | 6
request 2 | 8

# 3  
Old 02-24-2009
the code which u sent me would work even if there are multiple requests right...if i need to make a few modification like the below what would be the changes i need to make to the script u have provided me with..

request1 | 2 |4 | ied,ibd
request2 | 3 | 5 | fid,iweb
request1 | 4 | 5 | wwinf,ied
request2 | 3 | 3 | iweb,ied

result should be


request1 | 6 |9 | ied,ibd,wwinf
request2 |6 |7 | fid,iweb,ied
# 4  
Old 02-24-2009
sorry but i am new to scripting...
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

If I ran perl script again,old logs should move with today date and new logs should generate.

Appreciate help for the below issue. Im using below code.....I dont want to attach the logs when I ran the perl twice...I just want to take backup with today date and generate new logs...What I need to do for the below scirpt.............. 1)if logs exist it should move the logs with extention... (1 Reply)
Discussion started by: Sanjeev G
1 Replies

2. Shell Programming and Scripting

UNIX script for consolidated email

Hi, I am working on the below script to get a disk usage report in email from multiple unix systems but the problem I am getting first email with 1 system and second email with 2 systems and finally third email with all 3 systems :) Can someone please let me know how I can get single email... (4 Replies)
Discussion started by: new2prog
4 Replies

3. Shell Programming and Scripting

How to compare the current result with previous line result.?

Hi Gurus, I have requirement to compare current result with previous reuslt. The sample case is below. 1 job1 1 1 job2 2 1 job3 3 2 job_a1 1 2 job_a2 2 2 job_a3 3 3 job_b1 1 3 job_b2 2 for above sample file, GID is group ID, for input line, the job run... (1 Reply)
Discussion started by: ken6503
1 Replies

4. Shell Programming and Scripting

Consolidated output in shell script

Hi Gurus, I have a shell script which connects to mulitple DBs and run some queries and output will be written to log file.I need the consolidated output (html format will be better)from the logfile.see below for more details about my requirement. Actual output: DB_NAME TABLE_OWNER ... (9 Replies)
Discussion started by: navsan420
9 Replies

5. Shell Programming and Scripting

List no. of files in a directory/sub dir's and also an consolidated report as required

Need help on below query asap. Thanks. The below is the directory structure: /home/suren under /suren the following are the directories /bin /log /error /bin contains the following files abc.txt bcd.ksh cde.sh wer.ksh ghi (file with out any extension) /log contains the following... (1 Reply)
Discussion started by: sureng
1 Replies

6. UNIX for Dummies Questions & Answers

what is the result of this?

ls -A $variable (2 Replies)
Discussion started by: prathimahsc
2 Replies

7. Shell Programming and Scripting

Grep yesterday logs from weblogic logs

Hi, I am trying to write a script which would go search and get the info from the logs based on yesterday timestamp and write yesterday logs in new file. The log file format is as follows: """"""""""""""""""""""""""... (3 Replies)
Discussion started by: harish.parker
3 Replies

8. Solaris

Find files older than x days and create a consolidated single tar file.

Hello, I need help in finding files older than x days and creating a single consolidated tar file combining them. Can anyone please provide me a script? Thanks, Dawn (3 Replies)
Discussion started by: Dawn Bosch
3 Replies

9. UNIX for Dummies Questions & Answers

display the result of wc -l with words before and after the result

hello showrev -p | wc -l returns: 381 What to do in case I want to have this output: number of lines returned by showrev -p is: 381 thx (3 Replies)
Discussion started by: melanie_pfefer
3 Replies

10. Shell Programming and Scripting

Outputting formatted Result log file from old 30000 lines result log<help required>

Well I have a 3000 lines result log file that contains all the machine data when it does the testing... It has 3 different section that i am intrsted in 1) starting with "20071126 11:11:11 Machine Header 1" 1000 lines... "End machine header 1" 2) starting with "20071126 12:12:12 Machine... (5 Replies)
Discussion started by: vikas.iet
5 Replies
Login or Register to Ask a Question