01-25-2013
Comparing two files and creating a new file
Hi,
I want to compare two files based on the data in their first column. Both the files are not equal in their number of columns and number of entries or rows.
The entries (only the first column) of the
file1 should be compared with the entries (only the first column) of the
file2. If the data in the first column matches in both the files, then that data's corresponding row in the
file2 should be printed fully into a new file (
file3). This should be done as long as the entries in the
file1 has been fully compared with the
file2
file1
HTML Code:
1 0.25 0.56 0.56 0 55
5 0.99 0.44 0.89 0 89
7 0.77 0.45 0.75 0 100
file2
HTML Code:
1 0.25 0.56 0.56 0 6.565 6.555 1.589 7.892 70
2 0.88 0.25 0.77 0 6.458 4.215 1.588 7.222 80
5 0.99 0.44 0.89 0 7.444 5.444 7.444 9.221 90
7 0.77 0.45 0.75 0 4.225 4.256 7.555 2.222 10
8 0.14 0.44 0.78 0 2.457 4.222 8.777 1.454 20
The required output file (
file3) should look like:
HTML Code:
1 0.25 0.56 0.56 0 6.565 6.555 1.589 7.892 70
5 0.99 0.44 0.89 0 7.444 5.444 7.444 9.221 90
7 0.77 0.45 0.75 0 4.225 4.256 7.555 2.222 10
Last edited by begin_shell; 01-25-2013 at 11:38 AM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
There is a text file that contains the data in the following format:
COLUMN1 COLUMN2
ABC 1
ABC 2
ABC 3
DEF 4
DEF 5
XYZ 7
We have to create a second text file... (4 Replies)
Discussion started by: raina_nalin
4 Replies
2. Shell Programming and Scripting
Hi I have a problem trying to run a while statement.
I have files under one directory that i need to compare to a value in filex and update that file with the result
files in the directory are
DFC1.
DFC5.
DFC345.
DFC344.
DFC9.
The program i am trying to run will take the number... (3 Replies)
Discussion started by: SummitElse
3 Replies
3. Shell Programming and Scripting
File 1 data:
TestA
TestB
TestC
File 2 data:
TestA
TestD
TestE
My Output File (pick all from both and create a file without duplicate data)
----------------------------------------------------------------------
TestA
TestB
TestC (3 Replies)
Discussion started by: manmohanpv
3 Replies
4. Shell Programming and Scripting
Hi,
I have 2 files
file1
********
01-05-09|java.xls|
02-05-08|c.txt|
08-01-09|perl.txt|
01-01-09|oracle.txt|
********
file2
********
01-02-09|windows.xls|
02-05-08|c.txt|
01-05-09|java.xls|
08-02-09|perl.txt|
01-01-09|oracle.txt|
******** (8 Replies)
Discussion started by: shekhar_v4
8 Replies
5. Shell Programming and Scripting
Hello Everybody!!!!!!!!! Request you to help me with the below mentioned issue:
I have 2 files say,
File 1:
a|4|7
b|3|2
c|8|8
d|8|9
File 2:
a|4|6
b|2|2
c|8|8
d|9|8
The third file(output file) should have:
Data mismatch in row 1 column 3
Data mismatch in row 2 coumn 2
Data... (3 Replies)
Discussion started by: abhijeet1409
3 Replies
6. Shell Programming and Scripting
file1: (unique files)
1 /pub/atomicbk/catalog/catalog.gif 693
2 /pub/atomicbk/catalog/home.gif 813
3 /pub/atomicbk/catalog/logo2.gif 12871
4 /pub/atomicbk/catalog/sleazbk.html 18338
file2: (duplicate filenames allowed)
28/Aug/1995:00:00:38 1 /pub/atomicbk/catalog/home.gif 813... (2 Replies)
Discussion started by: jontjioe
2 Replies
7. UNIX for Dummies Questions & Answers
Hi
I am writing a script to run a loop through a directory and run a diff on each file against my test file.
I then want to time how long each file to process (not sure how time works), as well as how long all the files took as a whole to process.
Here is my code
#!/bin/bash
#Old... (1 Reply)
Discussion started by: ladyAnne
1 Replies
8. Shell Programming and Scripting
I want to compare 2 files and create third file with uncommon content.
e.g.
file1
ajay suhas tom nisha vijay mahish
file2
ajay suhas tom nisha
expected output file content
vijay mahish
Is it possible in single command ?
Thanks,
Ajay (6 Replies)
Discussion started by: ajaypatil_am
6 Replies
9. Shell Programming and Scripting
Hi All,
I have two files in the following format, with numbers being defined under columns(described by a set of headers) and rows(again defined by a set of identifiers)
2013 2013
Make200 Make201
Merc BMW
Jpur Del
... (9 Replies)
Discussion started by: dev.devil.1983
9 Replies
10. Shell Programming and Scripting
Hello Everybody
i am a newbie to the bash scripting.please can someone help me out here.i want to write a script on creating 10 users with passwords and comparing the users to the ones in /etc/passwd file.am i gonna use arrays in creating the 10 users or what?and again, how do i compare both... (1 Reply)
Discussion started by: bruno_brunt
1 Replies
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)