02-16-2007
Comparing Columns of two FIles
Dear all,
I have two files in UNIX File1 and File2 as below:
File1:
1,1234,.,67.897,,0
1,4134,.,87.97,,4
0,1564,.,97.8,,1
File2:
2,8798,.,67.897,,0
2,8879,.,77.97,,4
0,1564,.,97.8,,1
I want to do the following:
(1) Make sure that both the files have equal number of columns and if not error out
(2) If there are equal number of columns then compare each corresponding field from both the files line by line and if there is any difference then print the two different values with line number and column number.
I know that 'diff -w' is useful here because it compares ignoring leading, trailing or in-between spaces which is useful because all my columns are numeric.
Can I use say 'awk' and its NF and NR variables along with diff? Or is there any other way? Please advise. I thank you for your help.
GG
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Dear all,
I have two files in UNIX File1 and File2 as below:
File1:
1,1234,.,67.897,,0
1,4134,.,87.97,,4
0,1564,.,97.8,,1
File2:
2,8798,.,67.897,,0
2,8879,.,77.97,,4
0,1564,.,97.8,,1
I want to do the following:
(1) Make sure that both the files have equal number of columns and if... (1 Reply)
Discussion started by: ggopal
1 Replies
2. Shell Programming and Scripting
I have two files file1 and file 2
both are having multiple coloumns.i want to select only two columns.
i used following code to get the desired columns,with ',' as delimiter
cut -d ',' -f 1,2 file1 | sort > file1.new
cut -d ',' -f 1,2 file2 | sort > file2.new
I want to get the coloums... (1 Reply)
Discussion started by: bab123
1 Replies
3. Shell Programming and Scripting
Hey,
I have 2 files that have a name and then a number:
File 1:
dog 21
dog 24
cat 33
cat 27
dog 76
cat 65
File 2:
dog 109
dog 248
cat 323
cat 207
cat 66 (2 Replies)
Discussion started by: dcfargo
2 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I have two files with the same number of columns. Basically I want to print the 2 columns that match between the two files.
File1 looks like this:
dr12 12 6 abn
dr14 12 7 abn
File2 looks something like this:
dr12 12 8 abn
dr12 14 7 abn
So basically if the first... (1 Reply)
Discussion started by: kylle345
1 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I have two files. File1.txt has 2 columns and looks like:
458739 122345
4456 122657
34200 122600
File2.txt has many columns with column 1 the same as column2 of File1.txt, but with lot more rows:
122786 abcdefg user1@email
122778 uuhjeufh user2@email... (1 Reply)
Discussion started by: ursaan
1 Replies
6. Shell Programming and Scripting
Hello,
I have two files as 1.txt and 2.txt with number as columns.
1.txt
0 53.7988
1 -30.0859
2 20.1632
3 14.2135
4 14.6366
5 -37.6258
.
.
.
31608 -8.57333
31609 -2.58554
31610 -24.2857
2.txt (1 Reply)
Discussion started by: AKD
1 Replies
7. Shell Programming and Scripting
Hi - I have two files as follows:
File 1:
chr5 118464905 118465027 ENST00000514151 utr5 0 +
chr5 118464903 118465118 ENST00000504031 utr5 0 +
chr5 118468826 118469180 ENST00000504031 utr5 0 +
chr5 118469920 118470084 ... (14 Replies)
Discussion started by: polsum
14 Replies
8. Shell Programming and Scripting
Hi,
I have a single-column file1 having records like:
00AB01/11
43TG22/00
78RC09/34
......
......
and a second file , file 2 having two columns like
78RC09/34 1
45FD11/11 2
00AB01/11 3
43TG22/00 4
......
...... (8 Replies)
Discussion started by: amarn
8 Replies
9. Shell Programming and Scripting
Hey all, I have a file structure that looks something like this:
file1
306708278
88954535
234167885
file2
2012-03-27T12:32:56+00:00 137 Orchotorena 184616310003601409 306708278 es 40.4777947 Majadahonda -3.6416896333333333 0 false atlante83 "<a href=""http://tapbots.com/tweetbot""... (8 Replies)
Discussion started by: dgaff
8 Replies
10. UNIX for Advanced & Expert Users
Hi all,
I have two files as below. I need to compare field 2 of file 1 against field 1 of file 2 and field 5 of file 1 against filed 2 of file 2. If both matches , then create a result file 1 with first file data and if not matches , then create file with first fie data. Please help me in... (12 Replies)
Discussion started by: sivarajb
12 Replies
LEARN ABOUT DEBIAN
kdiff3
KDIFF3(1) General Commands Manual KDIFF3(1)
NAME
KDiff3 -- compares two or three input files or directories
SYNOPSIS
KDiff3 [QT options] [KDE options] [KDiff3 options] [File1/base] [File2] [File3]
DESCRIPTION
This manual page documents briefly the KDiff3 tool.
This manual page was written for the Debian distribution because the original program does not have a manual page. For comprehensive help,
please see khelpcenter help:/kdiff3.
KDiff3 is a program that
o compares or merges two or three text input files or directories
o shows the differences line by line and character by character
o provides an automatic merge-facility and
o an integrated editor for comfortable solving of merge-conflicts
o supports Unicode, UTF-8 and other codecs
o supports KIO on KDE (allows accessing ftp, sftp, fish, smb etc.)
o Printing of differences
o Manual alignment of lines
o Automatic merging of version control history ($Log$)
OPTIONS
This program follows the usual GNU command line syntax, with long options starting with two dashes (`-'). A summary of options is included
below. For a full summary of options, run KDiff3 --help.
-m, --merge
Merge the input.
-b, --base file
Explicit base file. For compatibility with certain tools.
-o, --output file
Output file. Implies -m. E.g.: -o newfile.txt
--out file
Output file, again. (For compatibility with certain tools.)
--auto No GUI if all conflicts are auto-solvable. (Needs -o file)
--qall Don't solve conflicts automatically. (For compatibility...)
-L1 alias
Visible name replacement for first file/base file.
-L2 alias
Visible name replacement for second file.
-L3 alias
Visible name replacement for third file.
-L, --fname alias
Visible name replacement. May by supplied for each input.
--cs string
Change a setting, e. g. --cs "AutoAdvance=1".
--confighelp
Show a list of all settings and their values.
--config file
Use a different settings file.
--author
Show author of program.
-v, --version
Show version of program.
--license
Show license of program.
AUTHOR
This manual page was written by Eike Sauer <eike@debian.org> for the Debian system (but may be used by others). Permission is granted to
copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 (or, at your option, any later
version published by the Free Software Foundation).
On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL.
KDIFF3(1)