Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Paste columns based on common column: multiple files
Top Forums Shell Programming and Scripting Paste columns based on common column: multiple files Post 303009584 by RudiC on Saturday 16th of December 2017 10:02:43 AM
Old 12-16-2017
Well, not one of my magic moments. Try instead
Code:
awk '
BEGIN           {TF = ARGC - 1
                }

                {if (!LINE[$2]) SEQ[++SN] = $2
                 LINE[$2] = LINE[$2] $0 " "
                 CNT[$2]++
                }
END             {for (s=1; s<=SN; s++) if (CNT[SEQ[s]] == TF) print LINE[SEQ[s]]
                }
'  HGWAS?/merged_info_CHR1.info

Only if you're running out of memory with too large or too many files, you might want to fall back to the post#9 version reading files twice but saving some memory.
 

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 (1 Reply)
Discussion started by: ks_reddy
1 Replies

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 (2 Replies)
Discussion started by: jjoe
2 Replies

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... (6 Replies)
Discussion started by: Lucky Ali
6 Replies

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 (9 Replies)
Discussion started by: quincyjones
9 Replies

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... (1 Reply)
Discussion started by: evelibertine
1 Replies

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>) { ... (3 Replies)
Discussion started by: Diya123
3 Replies

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 ... (1 Reply)
Discussion started by: alisrpp
1 Replies

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

9. Shell Programming and Scripting

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

Hello, I have a file with 2 columns ( tableName , ColumnName) delimited by a Pipe like below . File is sorted by ColumnName. Table1|Column1 Table2|Column1 Table5|Column1 Table3|Column2 Table2|Column2 Table4|Column3 Table2|Column3 Table2|Column4 Table5|Column4 Table2|Column5 From... (6 Replies)
Discussion started by: nv186000
6 Replies

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

LEARN ABOUT CENTOS

gedit

GEDIT(1)						      General Commands Manual							  GEDIT(1)

NAME

       gedit - text editor for the GNOME Desktop

SYNOPSIS

       gedit [OPTION...] [FILE...] [+LINE[:COLUMN]]
       gedit [OPTION...] -

DESCRIPTION

       gedit is the official text editor of the GNOME desktop environment.

       While  aiming  at simplicity and ease of use, gedit is a powerful general purpose text editor.  It can be used to create and edit all kinds
       of text files.

       gedit features a flexible plugin system which can be used to dynamically add new advanced features to gedit itself.

OPTIONS

       --encoding
	      Set the character encoding to be used for opening the files listed on the command line.

       -g, --geometry=GEOMETRY
	      Set the X geometry window size (WIDTHxHEIGHT+X+Y).

       --list-encodings
	      Display list of possible values for the encoding option and exit.

       --new-window
	      Create a new toplevel window in an existing instance of gedit.

       --new-document
	      Create a new document in an existing instance of gedit.

       -s, --standalone
	      Run gedit in standalone mode.

       -w, --wait
	      Open files and block the gedit process.

       --help Prints the command line options.

       --version
	      Output version information and exit.

       FILE   Specifies the file to open when gedit starts. If this is not specified, gedit will load a blank  file  with  an  "Unsaved  Document"
	      label. Multiple files can be loaded if they are separated by spaces.  gedit also supports handling of remote files. For example, you
	      can pass	the  location  of  a  webpage  to  gedit  ,  like  "http://www.gnome.org",  or	load  a  file  from  a	FTP  server,  like
	      "ftp://ftp.gnome.org/robots.txt".

       -      gedit will read from stdin

       +LINE  For  the first file, go to the line specified by LINE (do not insert a space between the "+" sign and the number).  If LINE is miss-
	      ing, go to the last line.

       COLUMN For the first file, go to the column specified by COLUMN.  If COLUMN is missing, go to the first column.

BUGS

       If you find a bug, please report it at http://bugzilla.gnome.org/enter_bug.cgi?product=gedit.

AUTHORS

       Paolo Maggi (paolo@gnome.org)

       Paolo Borelli (pborelli@katamail.com)

       Steve Frecinaux (code@istique.net)

       Jesse van den Kieboom (jessevdk@gnome.org)

       Ignacio Casal Quinteiro <icq@gnome.org>

       James Willcox (jwillcox@gnome.org)

       Federico Mena Quintero (federico@novell.com)

       Chema Celorio

								    17 May 2010 							  GEDIT(1)
All times are GMT -4. The time now is 09:50 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy