Adding columns of two files Post: 302113440

10 More Discussions You Might Find Interesting

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

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

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

4. Shell Programming and Scripting

adding columns

Hey everyone! I have a need to add 2 files together as columns. For instance, I have one file that has several rows of data and I want to take data from another file and add Line 1 to the end of Line1 in the first file file1 line1.........file2 line1 file1 line2.........file2 line2...

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

7. Shell Programming and Scripting

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: Each file has a great number of rows and columns. I need to add these files together the following way. In other words, If, for example, file A occupies Columns 1 to 19, I want to add file B...

8. Shell Programming and Scripting

Adding columns with values dependent on existing columns

Hello I have a file as below chr1 start ref alt code1 code2 chr1 18884 C CAAAA 2 0 chr1 135419 TATACA T 2 0 chr1 332045 T TTG 0 2 chr1 453838 T TAC 2 0 chr1 567652 T TG 1 0 chr1 602541 ...

9. Shell Programming and Scripting

Adding info to end of line if two columns match from files with different separators

I have two files (csv and vcf) which look exactly like this S1.csv func,gene,start,info "exonic","AL","2309","het" "exonic","NEF","6912","hom"S1.vcf ##fileinfo #CHROM POS ID INFO chr1 4567 rs323211 1/1:84,104,99 chr4 2309 rs346742 1/1:27,213,90 chr6 5834 ...

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

LEARN ABOUT CENTOS

column

COLUMN(1)							   User Commands							 COLUMN(1)

NAME

       column - columnate lists

SYNOPSIS

       column [options] file...

DESCRIPTION

       The column utility formats its input into multiple columns.  Rows are filled before columns.  Input is taken from file or, by default, from
       standard input.	Empty lines are ignored.

OPTIONS

       -c, --columns width
	      Output is formatted to a width specified as number of characters.

       -t, --table
	      Determine the number of columns the input contains and create a table.  Columns are delimited with whitespace, by default,  or  with
	      the characters supplied using the separator. Table output is useful for pretty-printing.

       -s, --separator separators
	      Specify possible table delimiters (default is whitespace).

       -o, --output-separator separators
	      Specify table output delimiter (default is two whitespaces).

       -x, --fillrows
	      Fill columns before filling rows.

       -h, --help
	      Print help and exit.

ENVIRONMENT

       The environment variable COLUMNS is used to determine the size of the screen if no other information is available.

EXAMPLES

       sed 's/#.*//' /etc/fstab | column -t

BUGS

       The util-linux version 2.23 changed -s option to be non-greedy, for example:

       $ printf "a:b:c
1::3
" | column  -t -s ':'

       old output:
       a  b  c
       1  3

       new output (since util-linux 2.23)
       a  b  c
       1     3

SEE ALSO

       colrm(1), ls(1), paste(1), sort(1)

HISTORY

       The column command appeared in 4.3BSD-Reno.

AVAILABILITY

       The column command is part of the util-linux package and is available from ftp://ftp.kernel.org/pub/linux/utils/util-linux/.

util-linux							   October 2010 							 COLUMN(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Adding columns to excel files using Perl

Discussion started by: dolo21taf

2. Shell Programming and Scripting

comparing files - adding/subtracting/formating columns

Discussion started by: oabdalla

3. Shell Programming and Scripting

awk adding columns from different files

Discussion started by: dsstamps

4. Shell Programming and Scripting

adding columns

Discussion started by: Kelam_Magnus