Need to append columns for every run


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need to append columns for every run
# 1  
Old 02-08-2011
Need to append columns for every run

Hi,
I have a requirement where I need to append the runtimes of the jobs for every run.
I have some 100 jobname and it will be static in output(1st column) . Everyday I need to run my script to find the runtimes for that day and add the entire 100 runtimes to the right of those 100 jobs(2nd column) . Next day to the right of those 100 runtimes(3rd column) and soon.
Is there any way to append like that ?

Thanks
Ajay
# 2  
Old 02-08-2011
How do you get the run-time of the scripts? Do you store it in a variable or..?
And how do you append those 100 run-times to the 2nd or 3rd column..?
# 3  
Old 02-08-2011
Ill get the runtimes from the logs for each run..for eg, for todays run, ill calculate the runtimes of all the jobs and put them in a txt file line by line. I dont know how to append it in 2nd /3rd/... columns of the output file.
I need to paste all these runtimes in the text file to that output file, but that should be appended (columnwise) .
# 4  
Old 02-08-2011
Post few samples of the "run-times" and the output you expect. People here would help you appending.
Or post few line of logs, we could even extract the run-time directly from the log and append.
# 5  
Old 02-08-2011
Hi,
Runtimes are in mins.
Code:
Jobname|Run time(mins)|Run time(mins)
---------------------------------------
xyz       |127               |130
abc       |80                 |81
sdf       |50                 |50
lkj        |140                |140

In the above table, Jobname is static. whenever I run the script that run times(mins) should get appended. I know how to get the runtimes, but donno how to append them.

Thanks
Ajay

Last edited by Franklin52; 02-09-2011 at 03:16 AM.. Reason: Please use code tags
# 6  
Old 02-08-2011
that's the expect output, where is your sample data?
# 7  
Old 02-08-2011
This will be my sample data in a txt file.

20110208(mins)
---------------
127
42
45
60
50

For every run a new file will be created like above and it needs to get appended to the output file as shown in my previous post.

Thanks
Ajay
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Programming

Python script to run multiple command and append data in output csv file

Experts, I am writing a script and able to write only small piece of code and not able to collect logic to complete this task. In input file have to look for name like like this (BGL_HSR_901_1AG_A_CR9KTR10) before sh iss neors. Record this (BGL_HSR_901_1AG_A_CR9KTR10) in csv file Now have to... (0 Replies)
Discussion started by: as7951
0 Replies

2. Shell Programming and Scripting

awk dynamically append columns into file

Hi, I have a large data file, want to separate it into 100 part and export one specific field as a file; then I want to append each part's column into one file. How to realize that? 1 2 3 1 2 3 4 2 2 3 4 3 3 3 4 4 3 4 5 5 3 4 5 6 I want the last column of the data file, e.g divide it... (5 Replies)
Discussion started by: wanliushao
5 Replies

3. Shell Programming and Scripting

First run overwrite then append

I'm overwriting .unl in first run and after that in seq. runs appending by following method. Any other method or command can do it easier? ARY_VALUE=1 while do if ; then type.sql > out.unl else type.sql >>out.unl fi ARY_VALUE--; done (3 Replies)
Discussion started by: Roozo
3 Replies

4. UNIX for Dummies Questions & Answers

append a column by concatenating other columns

Hi In a tab delimited file how can I add a column that have values concatenated from all columns. For example input.txt test1 test2 test3 zz2 mm uu pp3 yy kk ss2 tt ll zz3 mm uu pp23 yy kk ss3 tt ll 11e 22 44 33c 22 99 output.txt test1 test2 test3 reslt (6 Replies)
Discussion started by: mary271
6 Replies

5. Shell Programming and Scripting

To append two columns without double quotes

Hi i have a file with follw data "20090427","0","","16371311","-100200","","","","16371311","JUL","09" In the 10th column i need to convert the month name into month number in this case JUL will be 7 and append the 10th and 11th column which shows me the output as 709. Can you suggest a shell... (11 Replies)
Discussion started by: vee789
11 Replies

6. Shell Programming and Scripting

question about append columns

I like to do the following, please help! Thanks a lot for f in seq(f1 f2 f3 g1 h1 t2) do cut -d "+" -f2 $f > $f.nums paste ? # each loop will attach additional column to the created file $f.nums, how to do this??? done (1 Reply)
Discussion started by: ksgreen
1 Replies

7. Shell Programming and Scripting

append an output file with two columns

Hi All, can you help me with this: grep XXX dir/*.txt|wc -l > newfile.txt - this put the results in the newfile.txt, but I want to add another column in the newfile.txt, string 'YYYYY', separated somehow, which corresponds on the grep results? For example grep will grep XXX dir/*.txt|wc -l >... (5 Replies)
Discussion started by: apenkov
5 Replies

8. Programming

Compare two files of 4 columns and o/p unique,append zero's

I have to files File1 1 23 2 34 3 7 4 56 5 61 6 22 7 65 File2 2 21 4 32 7 22 Now i need to compare column1 of both the files and generate a third file which should contain all the values of 1st column of 1st file and in the second column i need to get the coressponding row... (2 Replies)
Discussion started by: kamuju
2 Replies

9. UNIX for Dummies Questions & Answers

append files as columns

Hi, I will rephrase my question. I have two files: q16 1.341E+05 wf8 3.084E+02 total1 1.344E+05 ud35 5.694E+03 us38 9.367E+05 ya23r 9.414E+02 up23s 2.403E+04 io240 1.203E+04 q16 1.341E+05 wf8 3.084E+02 total1 1.344E+05 ud35 5.694E+03 us38 9.367E+05 (2 Replies)
Discussion started by: f_o_555
2 Replies

10. Shell Programming and Scripting

Append string to columns from 2 files

Hi Having a file as follows file1.txt Date (dd/mm)Time Server IP Error Code =========================================================================== 10/04/2008 10:10 ServerA xxx.xxx.xxx.xxx 6 10/04/2008 10:10 ServerB ... (3 Replies)
Discussion started by: karthikn7974
3 Replies
Login or Register to Ask a Question