Add fields in different files only if some fields between them match Post: 302527864

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Match two files and divide fields

I have two files that have the date field in common. I request your help with some script that divide each field value from file1 by the correspond field value of the file2 only when the field date is equal in both files. Thanks in advance ! This is a sample of the files file 1 12/16/2010,...

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. Shell Programming and Scripting

how to match fields from different files in PERL

4. Shell Programming and Scripting

awk help: Match data fields from 2 files & output results from both into 1 file

I need to take 2 input files and create 1 output based on matches from each file. I am looking to match field #1 in both files (Userid) and create an output file that will be a combination of fields from both file1 and file2 if there are any differences in the fields 2,3,4,5,or 6. Below is an...

5. Shell Programming and Scripting

awk partial string match and add specific fields

Trying to combine strings that are a partial match to another in $1 (usually below it). If a match is found than the $2 value is added to the $2 value of the match and the $3 value is added to the $3 value of the match. I am not sure how to do this and need some expert help. Thank you :). file ...

6. Shell Programming and Scripting

awk to print fields that match using conditions and a default value for non-matching in two files

Trying to use awk to match the contents of each line in file1 with $5 in file2. Both files are tab-delimited and there may be a space or special character in the name being matched in file2, for example in file1 the name is BRCA1 but in file2 the name is BRCA 1 or in file1 name is BCR but in file2...

7. UNIX for Beginners Questions & Answers

Match Fields between two files, print portions of each file together when matched in ([g]awk)'

I've written an awk script to compare two fields in two different files and then print portions of each file on the same line when matched. It works reasonably well, but every now and again, I notice some errors and cannot seem to figure out what the issue may be and am turning to you for help. ...

8. UNIX for Beginners Questions & Answers

awk match two fields in two files

Hi, I have two TEST files t.xyz and a.xyz which have three columns each. a.xyz have more rows than t.xyz. I will like to output rows at which $1 and $2 of t.xyz match $1 and $2 of a.xyz. Total number of output rows should be equal to that of t.xyz. It works fine, but when I apply it to large...

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

Is there a UNIX command that can compare fields of files with differing number of fields?

Hi, Below are the sample files. x.txt is from an Excel file that is a list of users from Windows and y.txt is a list of database account. $ head -500 x.txt y.txt ==> x.txt <== TEST01 APP_USER_PROFILE USER03 APP_USER_PROFILE TEST02 APP_USER_EXP_PROFILE TEST04 APP_USER_PROFILE USER01 ...

LEARN ABOUT DEBIAN

h5diff

h5diff(1)						      General Commands Manual							 h5diff(1)

NAME

       h5diff - Compares two HDF5 files and reports the differences.

SYNOPSIS

       h5diff file1 file2 [OPTIONS] [object1 [object2 ] ]

DESCRIPTION

       h5diff is a command line tool that compares two HDF5 files, file1 and file2, and reports the differences between them.

       Optionally,  h5diff  will compare two objects within these files. If only one object, object1, is specified, h5diff will compare object1 in
       file1 with object1 in file2. In two objects, object1 and object2, are specified, h5diff will compare  object1  in  file1  with  object2	in
       file2. These objects must be HDF5 datasets.

       object1 and object2 must be expressed as absolute paths from the respective file's root group.

       Additional information, with several sample cases, can be found in the document H5diff Examples.

OPTIONS

       file1 file2
	      The HDF5 files to be compared.

       -h     Print all differences.

       -r     Print  only  the	names  of  objects that differ; do not print the differences. These objects may be HDF5 datasets, groups, or named
	      datatypes.

       -n count
	      Print difference up to count differences, then stop. count must be a positive integer.

       -d delta
	      Print only differences that are greater than the limit delta. delta must be a positive number. The comparison criterion  is  whether
	      the  absolute  value of the difference of two corresponding values is greater than delta (e.g., |a-b| > delta, where a is a value in
	      file1 and b is a value in file2).

       -p relative
	      Print only differences that are greater than a relative error. relative must be a  positive  number.  The  comparison  criterion	is
	      whether the absolute value of the difference 1 and the ratio of two corresponding values is greater than relative (e.g., |1-(b/a)| >
	      relative where a is a value in file1 and b is a value in file2).

       object1 object2
	      Specific object(s) within the files to be compared.

EXAMPLES

       The following h5diff call compares the object /a/b in file1 with the object /a/c in file2:
	   h5diff file1 file2 /a/b /a/c

       This h5diff call compares the object /a/b in file1 with the same object in file2:
	   h5diff file1 file2 /a/b

       And this h5diff call compares all objects in both files:
	   h5diff file1 file2

SEE ALSO

       h5dump(1), h5ls(1), h5repart(1), h5import(1), gif2h5(1), h52gif(1), h5perf(1)

																	 h5diff(1)