Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Need to append columns for every run

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need to append columns for every run
# 8  
Old 02-08-2011
how to identify the input txt file with different Jobname ?
# 9  
Old 02-08-2011
Im sorry, I dint get what you are asking
# 10  
Old 02-08-2011
Code:
$ cat times
137
84
50
145

$ cat runtimes
xyz |127 |130
abc |80 |81
sdf |50 |50
lkj |140 |140

$ paste -d\| runtimes times
xyz |127 |130|137
abc |80 |81|84
sdf |50 |50|50
lkj |140 |140|145

# 11  
Old 02-08-2011
Thanks Chubler XL. It is working, but I dont want to display that on the screen as there are somany jobs, so I need them to be put in the runtimes file after appending. Also is there any way to format that so that it will be clear lika a table(using /t)?

Thanks
Ajay
# 12  
Old 02-08-2011
By default paste uses tab as the delimiter (I used -d\| to change the delimiter to pipe as your existing file seemed to use pipe) take this out to use tab. to overwrite your runtimes file re-direct to temp file and then move that over the top of runtimes:

Code:
$ paste runtimes times > /tmp/paste.times.$$
$ mv /tmp/paste.times.$$ runtimes
$ rm /tmp/paste.times.$$

This User Gave Thanks to Chubler_XL For This Post:
ajayakunuri
# 13  
Old 02-08-2011
Thanks Chubler. This exactly suits my requirement.

---------- Post updated at 10:05 PM ---------- Previous update was at 09:59 PM ----------

1 last question. Is it possible to paste it in tabular format?

$paste runtimes newrun- it is giving the following output.

jobname 20110108
xyz 25
abc 24
dfg 26
# 14  
Old 02-08-2011
I get a tab as the delimiter so pasting times file x3 gives:

Code:
$ paste runtimes times times times
xyz     137     137     137
abc     84      84      84
sdf     50      50      50
lkj     145     145     145

Isn't that what you want?
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