Sponsored Content
Top Forums Shell Programming and Scripting Differences between 2 Flat Files and process the differences Post 302438008 by newbie_8398 on Saturday 17th of July 2010 09:30:36 AM
Old 07-17-2010
Differences between 2 Flat Files and process the differences

Hi
Hope you are having a great weeknd !! I had a question and need your expertise for this :

I have 2 files File1 & File2(of same structure) which I need to compare on some columns. I need to find the values which are there in File2 but not in File 1 and put the Differences in another file which I need to process

File 1
Code:
Field1 Field2 Field3 Field4 Field5 Field6
1      2      3      4      5      6
1      23     3      43     12     15

File 2
Code:
Field1 Field2 Field3 Field4  Field5 Field6
1      2      3      4       5      6
1      23     3      43      5      6 (not in diff field 5& 6 have changed which are not in compare condition)
1      23     3      12      5      6
31     43     54     5       7      8

Diff File
Code:
Field1 Field2 Field3  Field4  Field5 Field6
31     43     54      5       7      8 (in diff as its in File2 and not in File 1)
1      23     3       12      5      6 (in diff as its in File2(field4 has changed) and not in File 1)

So I need to compare only for the first 4 fields (i.e if any of those 4 fields are different then we need to pu them in the diff file and process it)


Any Help will be greatly appreciated!!

Thanks
J

Last edited by Scott; 07-17-2010 at 01:51 PM.. Reason: Code tags, please...
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Number of differences between 2 files

Hi, "diff" command takes two file names as arguements and gives the difference between the two. How do I get the number of differences between two files ??? (Excluding whitespaces). Don't ask me to count number of lines produced by "diff". Thanks in advance, Sharath (4 Replies)
Discussion started by: sharuvman
4 Replies

2. Solaris

Differences between jar files

I want to find the difference between two jar files sitting on a sun box. How do I do this? (3 Replies)
Discussion started by: runnerpaul
3 Replies

3. Shell Programming and Scripting

Detect differences in two files

All, I have two csv files, the format of which are exactly the same. I would like to find differences between the two files but would like to identify the difference as opposed to just printing a different line. For exmaple File 1 xxx,yyy,zzz,1,2,3 111,222,333,xxx,yyy ... (4 Replies)
Discussion started by: pxy2d1
4 Replies

4. Shell Programming and Scripting

Eliminating differences in two files

Hello, I'm having trouble to read two txt files, they have employee records line by line, I need to do the reading of a file that is old and compare it with the new base in the new file, deleting the lines in old file, then add the new file data from the old file and write to the database manager.... (5 Replies)
Discussion started by: selmar
5 Replies

5. UNIX for Dummies Questions & Answers

Finding differences between 2 text files

Hi everyone, I know that's a deep treated issue but I'm actually not able to find the solution. I have 2 plain text files with ~ 2000 rows and ~5 columns. The first column of the shortest file (f1) is fully contained by the first column of the biggest one (f2), but only that column. I want to... (6 Replies)
Discussion started by: OBAFGKM
6 Replies

6. AIX

Aix process CPU differences.

Hi, I'm trying to create a script to catch a process which is consuming high CPU which I have pretty much done but it's just finding the correct place to pull the current CPU for that process. When viewed in Topas it's consuming 99.*% cpu But if I try using ps avg or ps -eo pcpu ... (5 Replies)
Discussion started by: elmesy
5 Replies

7. Shell Programming and Scripting

Comparing two files and list the differences

Hi * I have two text files which has the file size, timestamp and the file name. I need to compare these two files and get the differences in the output format. Can anyone help me out with this. * cat file1.txt *474742 Apr 18* 2010 sample.log *135098 Apr 18* 2010 Testfile 134282 Apr 18* 2010... (7 Replies)
Discussion started by: Sendhil.Kumaran
7 Replies

8. Shell Programming and Scripting

Help comparing 2 files and sending differences

I have 2 files that need to be compared. Email the differences if something is different and don't email if nothing is different. One or both of the files could be empty. One or both could have data in them. example files backup.doc.$(date +%y%m%d) file size is 0 backup.doc.$(TZ=CST+24... (4 Replies)
Discussion started by: jabbott3
4 Replies

9. Shell Programming and Scripting

Need to compare the two files and list out differences between the two

Hi, I need to compare the two files and list out difference between the two. Please assist. Best regards, Vishal (2 Replies)
Discussion started by: Vishal_dba
2 Replies

10. Shell Programming and Scripting

How to do find differences between 2 XML Files?

Hello All, Requirement is to compare 2 XML files and see if there are any differences but from some of the providers We are receiving UTF-16 formatted XML file with no end of line as shown below. Excerpt of data file: ÿþ<^@?^@x^@m^@l^@ ^@v^@e^@r^@s^@i^@o^@n^@=^@"^@1^@.^@0^@"^@... (11 Replies)
Discussion started by: Ariean
11 Replies
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)
All times are GMT -4. The time now is 05:48 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy