Sponsored Content
Top Forums Shell Programming and Scripting How to compare 2 files and update one? Post 302843918 by roy121 on Thursday 15th of August 2013 04:21:12 PM
Old 08-15-2013
Linux How to compare 2 files and update one?

Hi,

I have got 2 files which i need to compare and append based on the below conditions.

file 1:

File 1 has data in the following format

Code:
4300 2356
C234 5689
5500 2345

File 2 has data in the same fomat

Code:
4300 49
5555 12345

Now i need to compare the first 4 bytes in each line from file2 and see if it exists on file1, and if they match ( they may be present in any position), i need to append the values present in pos6 onwards in sorted order

For example, for the number 4300 the value should come as

4300 234569

and if the number in the 1st 4 bytes of file 2 is not found in file 1 , i need to append the whole line to file 1.

How can this be done......need help....anyone plzzz SmilieSmilieSmilieSmilie

Last edited by jim mcnamara; 08-15-2013 at 05:34 PM..
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

compare update time of files

Hi, does anyone know of a way to compare files update time (not only days - also hours and minutes) (command? scripts? perl scripts?) Dori (8 Replies)
Discussion started by: dorilevy
8 Replies

2. Shell Programming and Scripting

How to compare data in two flat files and update them?

Hi All, I am giving an example similar to the problem I have. I have two data files of 10 columns each in which fields are delimited by comma(,). I need to compare compare the two files using the uniq col(col3). If there are any records in file1 and are not in file2 then I have check the value... (3 Replies)
Discussion started by: rajus19
3 Replies

3. Shell Programming and Scripting

compare two files and to remove the matching lines on both the files

I have two files and need to compare the two files and to remove the matching lines from both the files (4 Replies)
Discussion started by: shellscripter
4 Replies

4. Shell Programming and Scripting

compare files in two directories and output changed files to third directory

I have searched about 30 threads, a load of Google pages and cannot find what I am looking for. I have some of the parts but not the whole. I cannot seem to get the puzzle fit together. I have three folders, two of which contain different versions of multiple files, dist/file1.php dist/file2.php... (4 Replies)
Discussion started by: bkeep
4 Replies

5. Shell Programming and Scripting

How to compare 2 files & get only few columns based on a condition related to both files?

Hiiiii friends I have 2 files which contains huge data & few lines of it are as shown below File1: b.dat(which has 21 columns) SSR 1976 8 12 13 10 44.00 39.0700 70.7800 7.0 0 0.00 0 2.78 0.00 0.00 0 0.00 2.78 0 NULL ISC 1976 8 12 22 32 37.39 36.2942 70.7338... (6 Replies)
Discussion started by: reva
6 Replies

6. Shell Programming and Scripting

Compare 2 folders to find several missing files among huge amounts of files.

Hi, all: I've got two folders, say, "folder1" and "folder2". Under each, there are thousands of files. It's quite obvious that there are some files missing in each. I just would like to find them. I believe this can be done by "diff" command. However, if I change the above question a... (1 Reply)
Discussion started by: jiapei100
1 Replies

7. Shell Programming and Scripting

Require compare command to compare 4 files

I have four files, I need to compare these files together. As such i know "sdiff and comm" commands but these commands compare 2 files together. If I use sdiff command then i have to compare each file with other which will increase the codes. Please suggest if you know some commands whcih can... (6 Replies)
Discussion started by: nehashine
6 Replies

8. UNIX for Dummies Questions & Answers

Compare two flat files and update one based on the values in the other

Hi, I'm a newbie to scripting and am trying to compare two files using awk. The files are exactly the same dimensions. Where the first file has 0's I would like to create an updated version of the second file which has the corresponding elements set to zero also. eg: file1: 12345 1 2 0... (3 Replies)
Discussion started by: kasan0
3 Replies

9. Shell Programming and Scripting

Compare multiple files, and extract items that are common to ALL files only

I have this code awk 'NR==FNR{a=$1;next} a' file1 file2 which does what I need it to do, but for only two files. I want to make it so that I can have multiple files (for example 30) and the code will return only the items that are in every single one of those files and ignore the ones... (7 Replies)
Discussion started by: castrojc
7 Replies

10. Shell Programming and Scripting

Need solution to compare two file and update and append the output

Hi All, I have two files File1 frame,007C1 server1_Parent frame,007C3 server2_Silver frame,007EE server3_Bronze frame,00855 server4_Parent frame,00856 server4_Parent frame,00858 server5_Parent frame,008FA server6_Silver frame,008FB server6_Silver frame,008FC server6_Silver... (2 Replies)
Discussion started by: ranjancom2000
2 Replies
opendiff(1)						    BSD General Commands Manual 					       opendiff(1)

NAME
opendiff -- Use FileMerge to graphically compare or merge file or directories SYNOPSIS
opendiff file1 file2 [-ancestor ancestorFile] [-merge mergeFile] opendiff dir1 dir2 [-ancestor ancestorDirectory] [-merge mergeDirectory] DESCRIPTION
opendiff is a command line utility that provides a convenient way to launch the FileMerge application from Terminal to graphically compare files or directories. If FileMerge is already running, opendiff will connect to that running instance for the new comparison. opendiff exits immediately after the comparison request has been sent to FileMerge. opendiff and FileMerge can be used to compare two files file1 and file2 or to compare two directories dir1 and dir2. If the -ancestor flag is given, FileMerge will compare the two files or directories to a common ancestor. This is useful if two people inde- pendently modify copies of a single original file or directory. FileMerge lets you merge two files or directories together to create a third file or directory. To see the contents of a merged file, drag the splitter bar at the bottom of FileMerge's file comparison window. The contents of the merged file can be directly edited within File- Merge. After editing, the merged file can be saved to the file (or into the directory) specified with the Fl merge flag. If a destination is not specified with the -merge flag, FileMerge will ask for a destination file or directory when you try to save a merged file. For further information, please consult the Help information available from the FileMerge application. FILES
/Developer/Applications/Utilities/FileMerge.app opendiff and FileMerge are installed as part of the Mac OS X Developer Tools. SEE ALSO
diff(1), diff3(1), cmp(1) Mac OS X August 3, 2004 Mac OS X
All times are GMT -4. The time now is 07:33 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy