Adding Multiple Files via Columns


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Adding Multiple Files via Columns
# 1  
Old 10-27-2011
Adding Multiple Files via Columns

I have a number of files with multiple rows that I need to add together.
Let say I have 10 files:
Quote:
A, B, C, D, E, F, G, H, I, J.
Each file has a great number of rows and columns. I need to add these files together the following way.
Quote:
ABCDEFGHIJ
In other words, If, for example, file A occupies Columns 1 to 19, I want to add file B from column 20 to let ‘s say column 39 or whatever column it may be, then add file C from the end of file B to the next available bank column and so on until all the files are added.

Quote:
When I use this script:
while read line
do
sort -u $line >> file
for i in $line
do
awk '{print $0}' file >> file.xls
done
done<laf
I get this,
Quote:
A
B
C
D
E
F
G
H
I
J
# 2  
Old 10-27-2011
Look into 'man paste'.
# 3  
Old 10-27-2011
If you want to append to a single line then try printf ("%s", $0) instead of print $0 (and a printf ("\n") or an echo at the end).
# 4  
Old 10-27-2011
if i got this correct, you actualy need to read all first lines from all files then fix it in file or array, then read another line from all files and fix them and so on..
tip78
# 5  
Old 10-27-2011
Quote:
Originally Posted by tip78
if i got this correct, you actualy need to read all first lines from all files then fix it in file or array, then read another line from all files and fix them and so on..
Which is effectively what 'paste' does...
# 6  
Old 10-27-2011
Actually, I want to read the entire first file, in this case file A. Then I want to add the additional files as column arrays. Think about it as a matrix, instead of adding rows to file A, I want to add columns to it. Each file (B,C,D,E,F,G,H,I,J) would fill the empty columns to the right of the preceding file until all the files are entered.
So rather than having:
Quote:
[A]
[B]
.
.
[J]
I want to have
Quote:
[A B C...J].
Hope it's clear enough.
# 7  
Old 10-27-2011
don't over-complicate the task - look into 'paste' first.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Adding columns from 2 files with variable number of columns

I have two files, file1 and file2 who have identical number of rows and columns. However, the script is supposed to be used for for different files and I cannot know the format in advance. Also, the number of columns changes within the file, some rows have more and some less columns (they are... (13 Replies)
Discussion started by: maya3
13 Replies

2. Shell Programming and Scripting

Removing carriage returns from multiple lines in multiple files of different number of columns

Hello Gurus, I have a multiple pipe separated files which have records going over multiple Lines. End of line separator is \n and records going over multiple lines have <CR> as separator. below is example from one file. 1|ABC DEF|100|10 2|PQ RS T|200|20 3| UVWXYZ|300|30 4| GHIJKL|400|40... (7 Replies)
Discussion started by: dJHa
7 Replies

3. Shell Programming and Scripting

Compare multiple files with multiple number of columns

Hi, input file1 abcd 123 198 xyz1:0909090-0909091 ghij 234 999 xyz2:987654:987655 kilo 7890 7990 xyz3:12345-12357 prem 9 112 xyz5:97-1134 input file2 abcd 123 198 xyz1:0909090-0909091 -9.122 0 abed 88 98 xyz1:98989-090808 -1.234 1.345 ghij 234 999 xyz2:987654:987655 -10.87090909 5... (5 Replies)
Discussion started by: jacobs.smith
5 Replies

4. UNIX for Dummies Questions & Answers

Adding new columns to txt files

Dear all, I have a question. I have a txt.file as below. i want to add 3 more columns: column3=conlum 2*column2; column4=(1-column2)*(1-column2); column5=1-column3-column4. Do you know how to do it? Thanks a lot! file: column1 column2 a 1 b 20 c 30 d 3 ... (2 Replies)
Discussion started by: forevertl
2 Replies

5. Shell Programming and Scripting

merging files and adding special columns

Hi everyone, I got a problem with merging files and hoped one of you would have an idea how to approach this issue. I tried it with awk, but didn't get far. This is what I have: I got 40 files looking like the ones below. All have three columns but the number of rows differs (20000 to 50000).... (6 Replies)
Discussion started by: TuAd
6 Replies

6. Shell Programming and Scripting

Adding columns of two files

Hello everyone, I have two files containing 6 columns and thousands of rows. I want to add them (i.e. first column of first file + first column of second file and so on) and print the output in a third file. Can you please help me. Thanks a lot (7 Replies)
Discussion started by: chandra321
7 Replies

7. Shell Programming and Scripting

awk adding columns from different files

Hi, I have two files and I need to add column 3 of file1 to column 3 of file 2 > file3 I also need to repeat for column 4. Thanks (1 Reply)
Discussion started by: dsstamps
1 Replies

8. Shell Programming and Scripting

comparing files - adding/subtracting/formating columns

I have two files: file1.txt: FS Total Used Free Used% /u01 10000 8000 2000 80% /u02 10000 8000 2000 80% /u03 10000 8000 2000 80% /u04 10000 8000 2000 80% /u05 10000 8000 2000 80% /u06 10000 8000 2000 80% /u07 10000 8000 2000 80% /u10 10000 5000 5000 50% file2.txt:... (7 Replies)
Discussion started by: oabdalla
7 Replies

9. Shell Programming and Scripting

Adding Multiple Lines to Multiple Files

Hello, I have three lines I need to add to hundreds of files. The files are all in the same format and contain the same information. I want to add the same information to the files. The new lines of information are similar. Here is an example of the three lines: line1: line2 =... (2 Replies)
Discussion started by: dayinthelife
2 Replies

10. Shell Programming and Scripting

Adding columns to excel files using Perl

How do I add 4 columns to an excel file using Perl? The 4 headers for those columns will all have different names? Please help and I greatly appreciate... (1 Reply)
Discussion started by: dolo21taf
1 Replies
Login or Register to Ask a Question