Paste columns based on common column: multiple files Post: 303009533

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to convert 2 column data into multiple columns based on a keyword in a row??

Hi Friends I have the following input data in 2 columns. SNo 1 I1 Value I2 Value I3 Value SNo 2 I4 Value I5 Value I6 Value I7 Value SNo 3 I8 Value I9 Value ............... ................ SNo N

2. Shell Programming and Scripting

sum multiple columns based on column value

i have a file - it will be in sorted order on column 1 abc 0 1 abc 2 3 abc 3 5 def 1 7 def 0 1 -------- i'd like (awk maybe?) to get the results (any ideas)??? abc 5 9 def 1 8

3. Shell Programming and Scripting

Merging 2 files based on a common column

Hi All, I do have 2 files file 1 has 4 tab delimited columns 234 a c dfgyu 294 b g fih 302 c h jzh 328 z c san 597 f g son File 2 has 2 tab delimted columns 234 23 302 24 597 24 I want to merge file 2 with file 1 based on the data common in both files which is the first column so...

4. Shell Programming and Scripting

Join multiple files based on 1 common column

I have n files (for ex:64 files) with one similar column. Is it possible to combine them all based on that column ? file1 ax100 20 30 40 ax200 22 33 44 file2 ax100 10 20 40 ax200 12 13 44 file2 ax100 0 0 4 ax200 2 3 4

5. UNIX for Dummies Questions & Answers

Writing a loop to merge multiple files by common column

I have 100 data files labelled 250.1.txt through 250.100.txt. The second column of the data files partially match (there is about %90 overlap). Each data file has 4 columns. I want the merge all these text files by the matching values in the second column. In the output, the first column should...

6. Shell Programming and Scripting

common entries between files based on 1st column

Hi, I am trying to get the common entries from 2 files based on 1st field.. However when I try to do in perl I am getting blank output.. How can I do this in awk? open(BUFF1, "my_genes"); open(BUFF3, "rawcounts"); #open(WRBUFF,">result_rawcounts"); while($line =<BUFF1>) { ...

7. UNIX for Dummies Questions & Answers

How to join 2 .txt files based on a common column?

Hi all, I'm trying to join two .txt file tab delimitated based on a common column. File 1 transcript_id gene_id length effective_length expected_count TPM FPKM IsoPct comp1000201_c0_seq1 comp1000201_c0 337 183.51 0.00 0.00 0.00 0.00 comp1000297_c0_seq1 ...

8. UNIX for Dummies Questions & Answers

Merge selective columns from files based on common key

Hi, I am trying to selectively merge two files based on keys reported in the 1st column. File1: #file1-header1 file1-header2 111 qwe rtz uio 198 asd fgh jkl 165 yxc 789 poi uzt rew 89 lkj File2: #file2-header2 file2-header2 165 ghz nko2 ...

9. Shell Programming and Scripting

Join columns across multiple lines in a Text based on common column using BASH

10. UNIX for Beginners Questions & Answers

How to copy a column of multiple files and paste into new excel file (next to column)?

I have data of an excel files as given below, file1 org1_1 1 1 2.5 100 org1_2 1 2 5.5 98 org1_3 1 3 7.2 88 file2 org2_1 1 1 2.5 100 org2_2 1 2 5.5 56 org2_3 1 3 7.2 70 I have multiple excel files as above shown. I have to copy column 1, column 4 and paste into a new excel file as...

LEARN ABOUT DEBIAN

sendemail

SendEmail(1)							   User Commands						      SendEmail(1)

NAME

       SendEmail - Lightweight, command line SMTP email client

SYNOPSIS

       SendEmail -f ADDRESS [options]

OPTIONS

       -f ADDRESS
	      from (sender) email address

	      * At least one recipient required via -t, -cc, or -bcc * Message body required via -m, STDIN, or -o message-file=FILE

	      Common:

       -t ADDRESS [ADDR ...]
	      to email address(es)

       -u SUBJECT
	      message subject

       -m MESSAGE
	      message body

       -s SERVER[:PORT]
	      smtp mail relay, default is localhost:25

	      Optional:

       -a     FILE [FILE ...]	   file attachment(s)

       -cc    ADDRESS [ADDR ...]   cc  email address(es)

       -bcc ADDRESS [ADDR ...]
	      bcc email address(es)

	      [32;1mParanormal:[m

       -xu USERNAME
	      authentication user (for SMTP authentication)

       -xp PASSWORD
	      authentication password (for SMTP authentication)

       -l     LOGFILE		    log to the specified file

       -v     verbosity, use multiple times for greater effect

       -q     be quiet (no stdout output)

       -o NAME=VALUE
	      see extended help topic "misc" for details

	      Help:

       --help TOPIC
	      The following extended help topics are available:

       addressing
	      explain addressing and related options

       message
	      explain message body input and related options

       misc   explain -xu, -xp, and others

       networking
	      explain -s, etc

       output explain logging and other output options

REPORTING BUGS

       Report bugs to <http://bugs.debian.org/sendemail>

AUTHOR

       sendemail was written by Brandon Zehm <caspian@dotconf.net> .

       This  manual  page  was written by Brandon Zehm and improved by Alejandro Garrido Mota <garridomota@gmail.com>, for the Debian project (and
       may be used by others).

sendEmail							  September 2010						      SendEmail(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to convert 2 column data into multiple columns based on a keyword in a row??

Discussion started by: ks_reddy

2. Shell Programming and Scripting

sum multiple columns based on column value

Discussion started by: jjoe

3. Shell Programming and Scripting

Merging 2 files based on a common column

Discussion started by: Lucky Ali

4. Shell Programming and Scripting

Join multiple files based on 1 common column

Discussion started by: quincyjones