Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

question about append columns

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting question about append columns
# 1  
Old 11-15-2010
question about append columns
I like to do the following, please help! Thanks a lot
Code:
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

Last edited by Scott; 11-15-2010 at 11:22 AM.. Reason: Please use code tags
# 2  
Old 11-15-2010
You weren't very clear on what the output should be like (I'm assuming you want a + seperator in the output too)

Code:
prev=
for f in f1 f2 f3 g1 h1 t2
do
    if [ -z "$prev" ]
    then
        cut -d+ -f2 $f > $f.nums 
    else
        cut -d+ -f2 $f | paste -d+ $prev - > $f.nums
    fi  
    prev=$f.nums
done

---------- Post updated at 03:23 AM ---------- Previous update was at 03:12 AM ----------

Here is another solution that's shorter, but probably harder to follow:

Code:
PASTECMD="cat -"
for f in f1 f2 f3 g1 h1 t2
do
    cut -d+ -f2 $f | $PASTECMD > $f.nums
    PASTECMD="paste -d+ $f.nums -"
done

PASTCMD on first loop is cat of standard input (simple copy stdin to stdout). It is then changed for 2nd (and subsiquent) loops to paste stdin to the previous file.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

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

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

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

4. Shell Programming and Scripting

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... (19 Replies)
Discussion started by: ajayakunuri
19 Replies

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

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

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

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

9. UNIX and Linux Applications

ftp append question

Quick question. Will append act like 'put' if the file I'm telling it to append to doesn't exist? (2 Replies)
Discussion started by: Lindarella
2 Replies

10. UNIX for Dummies Questions & Answers

append question

I have a .pl script that is grabbing information and creating two different .txt files, I need to append one to the other. open GARPFILE; open GARPFILEXX; cat $gGarpFileXx >> $gGarpFile; close GARPFILE; close GARPFILEXX; but I'm getting this: Useless use... (1 Reply)
Discussion started by: mr_evans2u
1 Replies
Login or Register to Ask a Question