Match columns several files Post: 302791319

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Match strings in two files and compare columns of both

Good Morning, I was wondering if anybody could tell me how to achieve the following, preferably with a little commenting for understanding. I have 2 files, each with multiple rows with multiple columns. I need to find each row where the value in column 1 of file 1 matches column 1...

2. UNIX for Dummies Questions & Answers

Two files; if cells match then copy over other columns

My current issue is dealing with two space delimited files. The first file has column 1 as the sample ID's, then columns 2 - n as the observations. The second file has column 1 as the sample ID's, column 2 as the mother ID's, column 3 as the father ID's, column 4 as the gender, and column 5...

3. Shell Programming and Scripting

Match files based on either of the two columns awk

Dear Shell experts, I have 2 files with structure: File 1: ID and count head test_GI_count1.txt 1000094 2 10039307 1 10039641 1 10047177 11 10047359 1 1008555 2 10120302 1 10120672 13 10121776 1 10121865 32 And 2nd file: head Protein_gi_GeneID_symbol.txt protein_gi GeneID...

4. Shell Programming and Scripting

Match two columns from two files and print output

Hello, I have two files which are of the following format File 1 which has two columns Protein_ID Substitution NP_997239 T53R NP_060668 V267M NP_058515 P856A NP_001206 T55M NP_006601 D371Y ...

5. Shell Programming and Scripting

Match the columns between 2 files

I have two files I want to match ids in the 5th column of the file 1 with the first column of the file 2 and get the description for the matched ids as shown in the output sno nm no nm2 ID 1 cc 574372 yyyi |6810|51234| 2 bb 119721 nmjk |6810|51234|51179| ...

6. Shell Programming and Scripting

Return first two columns if match found among two files

Hi, I have FileA with one column. File B with 15 columns separated by comma delimiter. I need to compare the FILEA value with all 15 columns of FILEB... if matches, need to return the 1st, 2nd column values of FILEB. How to achieve this through shell script? Thanks in advance.

7. Shell Programming and Scripting

Match first two columns and average third from multiple files

I have the following format of input from multiple files File 1 24.01 -81.01 1.0 24.02 -81.02 5.0 24.03 -81.03 0.0 File 2 24.01 -81.01 2.0 24.02 -81.02 -5.0 24.03 -81.03 10.0 I need to scan through the files and when the first 2 columns match I...

8. UNIX for Dummies Questions & Answers

Match the columns between two files and output

Hi Help, I have two files namely a.txt and b.txt a.txt looks like a.txt 1 2 2 1 3 3 2 4 4 4 5 6 6 7 7 b.txt looks like, b.txt 1 2 1 1 3 2 2 4 3 3 4 4 4 5 5

9. Shell Programming and Scripting

Comparing two columns in two files and printing a third based on a match

Hello all, First post here. I did not notice a previous post to help me down the right path. I am looking to compare a column in a CSV file against another file (which is not a column match one for one) but more or less when a match is made, I would like to append a third column that contains a...

10. UNIX for Beginners Questions & Answers

Data match 2 files based on first 2 columns matching only and join if match

Hi, i have 2 files , the data i need to match is in masterfile and i need to pull out column 3 from master if column 1 and 2 match and output entire row to new file I have tried with join and awk and i keep getting blank outputs or same file is there an easier way than what i am...

LEARN ABOUT REDHAT

queue

queue(n)							Tcl Data Structures							  queue(n)

NAME

       queue - Create and manipulate queue objects

SYNOPSIS

       package require Tcl 8.2

       package require struct ?1.2.1?

       queueName option ?arg arg ...?

       queueName clear

       queueName destroy

       queueName get ?count?

       queueName peek ?count?

       queueName put item ?item ...?

       queueName size

DESCRIPTION

       The  ::struct::queue command creates a new queue object with an associated global Tcl command whose name is queueName.  This command may be
       used to invoke various operations on the queue.	It has the following general form:

       queueName option ?arg arg ...?
	      Option and the args determine the exact behavior of the command.	The following commands are possible for queue objects:

       queueName clear
	      Remove all items from the queue.

       queueName destroy
	      Destroy the queue, including its storage space and associated command.

       queueName get ?count?
	      Return the front count items of the queue and remove them from the queue.  If count is not specified, it defaults to 1.  If count is
	      1, the result is a simple string; otherwise, it is a list.  If specified, count must be greater than or equal to 1.  If there are no
	      items in the queue, this command will return count empty strings.

       queueName peek ?count?
	      Return the front count items of the queue, without removing them from the queue.	If count is not specified, it defaults to  1.	If
	      count  is  1,  the  result is a simple string; otherwise, it is a list.  If specified, count must be greater than or equal to 1.	If
	      there are no items in the queue, this command will return count empty strings.

       queueName put item ?item ...?
	      Put the item or items specified into the queue.  If more than one item is given, they will be added in the order they are listed.

       queueName size
	      Return the number of items in the queue.

KEYWORDS

       stack, matrix, tree, graph

struct								       1.2.1								  queue(n)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Match strings in two files and compare columns of both

Discussion started by: GarciasMuffin

2. UNIX for Dummies Questions & Answers

Two files; if cells match then copy over other columns

Discussion started by: Renyulb28

3. Shell Programming and Scripting

Match files based on either of the two columns awk

Discussion started by: smitra

4. Shell Programming and Scripting

Match two columns from two files and print output

Discussion started by: nans