Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

append files as columns

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers append files as columns
# 1  
Old 12-15-2009
append files as columns
Hi,
I will rephrase my question. I have two files:

Code:
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

Code:
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
blah	1.234E+02
blah	1.234E+02
blah	1.234E+02

As you may see the number of line is not the same.

is there a way to join the two file so that I have one file with 4 columns if they have a different lenght?
something like

Code:
q16	1.341E+05	q16	1.341E+05
wf8	3.084E+02	wf8	3.084E+02
total1	1.344E+05	total1	1.344E+05
ud35	5.694E+03	ud35	5.694E+03
us38	9.367E+05	us38	9.367E+05
ya23r	9.414E+02	ya23r	9.414E+02
up23s	2.403E+04	up23s	2.403E+04
io240	1.203E+04	io240	1.203E+04
     	         	blah	1.234E+02
     	         	blah	1.234E+02
     	         	blah	1.234E+02

with spaces (TAB separated) replacing the values in the missing lines
Thank you,
Last edited by f_o_555; 12-15-2009 at 12:19 PM..
# 2  
Old 12-15-2009
wht do you mean by different length here ?

this may be of your interest ..
Code:
14:47:14 : tmp : cat t1
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
nextline  col2


14:47:18 : tmp : cat t2
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


14:47:49 : tmp : paste t1 t2
q16     1.341E+05       q16     1.341E+05
wf8     3.084E+02       wf8     3.084E+02
total1  1.344E+05       total1  1.344E+05
ud35    5.694E+03       ud35    5.694E+03
us38    9.367E+05       us38    9.367E+05
ya23r   9.414E+02       ya23r   9.414E+02
up23s   2.403E+04       up23s   2.403E+04
io240   1.203E+04       io240   1.203E+04
nextline  col2

# 3  
Old 12-15-2009
For example file1 may have 10 lines and file2 may have 20 lines.

I tried paste as you said but it is messing up if the files do not have the same length.

Any idea?
Last edited by f_o_555; 12-15-2009 at 06:37 AM..
 
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. Shell Programming and Scripting

Compare 2 csv files by columns, then extract certain columns of matcing rows

Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns. I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
Discussion started by: bkane3
5 Replies

3. Shell Programming and Scripting

Combine columns from many files but keep them aligned in columns-shorter left column issue

Hello everyone, I searched the forum looking for answers to this but I could not pinpoint exactly what I need as I keep having trouble. I have many files each having two columns and hundreds of rows. first column is a string (can have many words) and the second column is a number.The files are... (5 Replies)
Discussion started by: isildur1234
5 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

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

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

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

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

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