Match two files and divide fields Post: 302483418

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Match two files and divide a field !

Hello, I have two files that have the date field as a common. I request your help with some script that divide the value of the file1 by the value in the file2 only when the field date are the same between both files and create a new text file. This is a sample of the files file1...

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

Add fields in different files only if some fields between them match

Hi everybody (first time posting here) I have a file1 that looks like > 1,101,0.1,0.1 1,26,0.1,0.1 1,3,0.1,0.1 1,97,0.5,0.5 1,98,8.1,0.218919 1,99,6.2,0.248 2,101,0.1,0.1 2,24,3.1,0.147619 2,25,23.5,0.559524 2,26,34,0.723404with 762 lines.. I have another 'similar' file2 > ...

5. 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...

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

awk to print match or non-match and select fields/patterns for non-matches

In the awk below I am trying to output those lines that Match between file1 and file2, those Missing in file1, and those missing in file2. Using each $1,$2,$4,$5 value as a key to match on, that is if those 4 fields are found in both files the match, but if those 4 fields are not found then missing...

8. 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. ...

9. 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...

10. 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...

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)