Match data based on two fields, and append to a line Post: 302451222

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extract data based on match against one column data from a long list data

My input file: data_5 Ali 422 2.00E-45 102/253 140/253 24 data_3 Abu 202 60.00E-45 12/23 140/23 28 data_1 Ahmad 256 7.00E-45 120/235 140/235 22 data_4 Aman 365 8.00E-45 15/65 140/65 20 data_10 Jones 869 9.00E-45 65/253 140/253 18...

2. UNIX for Dummies Questions & Answers

Match values from 2 files and append certain fields

Hi, I need help on appending certain field in my file1.txt based on matched patterns in file2.txt using awk or sed. The blue color need to match with one of the data in field $2 in file2.txt. If match, BEGIN and FINISHED value in red will have a new value from field $3 and $4 accordingly. ...

3. UNIX for Dummies Questions & Answers

using sed delete a line from csv file based on specific data in two separate fields

Hello, :wall: I have a 12 column csv file. I wish to delete the entire line if column 7 = hello and column 12 = goodbye. I have tried everything that I can find in all of my ref books. I know this does not work /^*,*,*,*,*,*,"hello",*,*,*,*,"goodbye"/d Any ideas? Thanks Please...

4. UNIX for Dummies Questions & Answers

How to remove fields space and append next line to previous line.?

awk 'BEGIN{FS = "�"} NR == 1 {p = $0; next} NF > 1 {print p; p = $0} NF <= 1 {p = (p " " $0)} END {print p}' input.txt > output.txt This is what the input data file looks like with broken lines Code: 29863 �890000000 �543209911 �CHNGOHG �000000001 �055 ...

5. Shell Programming and Scripting

Match and Append Based on file contexts

Not Sure how to do this. Some combo of awk and sed perhaps. If String in File1 match String in file2 then append file2 File1.txt BullTerrier Boxer Bulldog File2.txt <Defined info="AllAnimals" group="Adoptions" setting="animals"> <SomeID ="NumbersRepresentingDogName"> <for> <add...

6. Shell Programming and Scripting

To append new data at the end of each line based on substring of last column

Hi guys, I need to append new data at the end of each line of the files. This new data is based on substring (3rd fields) of last column. Input file xxx.csv: U1234|1-5X|orange|1-5X|Act|1-5X|0.1 /sac/orange 12345 0 U5678|1-7X|grape|1-7X|Act|1-7X|0.1 /sac/grape 5678 0...

7. Shell Programming and Scripting

Append data with substring of nth column fields using awk

Hi guys, I have problem to append new data at the end of each line of the files where it takes whole value of the nth column. My expected result i just want to take a specific value only. This new data is based on substring of 11th, 12th 13th column that has comma seperated value. My code: awk...

8. Shell Programming and Scripting

awk to update file based on match in 3 fields

Trying to use awk to store the value of $5 in file1 in array x. That array x is then used to search $4 of file1 to find aa match (I use x to skip the header in file1). Since $4 can have multiple strings in it seperated by a , (comma), I split them and iterate througn each split looking for a match....

9. Shell Programming and Scripting

Matching two fields in two csv files, create new file and append match

I am trying to parse two csv files and make a match in one column then print the entire file to a new file and append an additional column that gives description from the match to the new file. If a match is not made, I would like to add "NA" to the end of the file Command that Ive been using...

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 HPUX

comm

comm(1) 						      General Commands Manual							   comm(1)

NAME

       comm - select or reject lines common to two sorted files

SYNOPSIS

       file1 file2

DESCRIPTION

       comm  reads  file1  and	file2, which should be ordered in increasing collating sequence (see sort(1) and Environment Variables below), and
       produces a three-column output:

	      Column 1:   Lines that appear only in file1,
	      Column 2:   Lines that appear only in file2,
	      Column 3:   Lines that appear in both files.

       If is used for file1 or file2, the standard input is used.

       Options 1, 2, or 3 suppress printing of the corresponding column.  Thus prints only the lines common to the two files; prints only lines in
       the first file but not in the second; does nothing useful.

EXTERNAL INFLUENCES

   Environment Variables
       determines the collating sequence expects from the input files.

       determines the language in which messages are displayed.

       If is not specified in the environment or is set to the empty string, the value of determines the language in which messages are displayed.
       If is not specified in the environment or is set to the empty string, the value of is used as a default.  If is not specified or is set	to
       the  empty  string,  a  default of ``C'' (see lang(5)) is used instead of If any internationalization variable contains an invalid setting,
       behaves as if all internationalization variables are set to ``C''.  See environ(5).

   International Code Set Support
       Single- and multi-byte character code sets are supported.

EXAMPLES

       The following examples assume that and have been ordered in the collating sequence defined by the or environment variable.

       Print all lines common to and (in other words, print column 3):

       Print all lines that appear in but not in (in other words, print column 1):

       Print all lines that appear in but not in (in other words, print column 2):

SEE ALSO

       cmp(1), diff(1), sdiff(1), sort(1), uniq(1).

STANDARDS CONFORMANCE

																	   comm(1)