Compare two files and output diff to third file Post: 302239879

Sponsored Content

Top Forums Shell Programming and Scripting Compare two files and output diff to third file Post 302239879 by altamaha on Wednesday 24th of September 2008 03:36:26 PM

09-24-2008

Registered User

Compare two files and output diff to third file

I have made several attempts to read two files of ip addresses and eliminate records from file1 that are in file2.

My latest attempt follows. Everything works except my file3 is exactly the same as file1 and it should not be.

Code:

# !/usr/bin/bash
#
# NoInterfaces
# Utility will create a file of ip addresses( file1) from an ARP file from network admin.
# Utility will create a file of interface ip addresses(file2) from an ARP file from network admin.
# Utility will create a file of user ip addresses(file3) from file1 and file2 created within utility
#

# set some variables
DIR=/export/home/gordonl
file1=$DIR/ipstrings     # Large file containing all arp ip strings
file2=$DIR/intfip        # small file containing interface ip strings
file3=$DIR/output.txt    # output file contains all of file1 - file2
# null the files
>$file1
>$file2
>$file3

# Locate all Internet IP Address strings from RtrARP
grep Internet $DIR/RtrARP | cut -d" " -f3 | sort -n -t . -k 1,1 -k 2,2 -k 3,3 -k 4,4 > $file1

# Locate all Router Interface strings
grep "ip address 1" $DIR/RtrARP | cut -d" " -f4 | sort -n -t . -k 1,1 -k 2,2 -k 3,3 -k 4,4 > $file2

while read HOST
do
   grep -v "$HOST" $file1 > $file3
done < $file2

thanks in advance for any help.

JB

altamaha

View Public Profile for altamaha

Find all posts by altamaha

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

diff 2 files; output diff's to 3rd file

Hello, I want to compare two files. All records in file 2 that are not in file 1 should be output to file 3. For example: file 1 123 1234 123456 file 2 123 2345 23456 file 3 should have 2345 23456 I have looked at diff, bdiff, cmp, comm, diff3 without any luck!

2. Shell Programming and Scripting

compare two files, diff the result

Hi Everyone, 1.txt 00:01:01 asdf 00:33:33 1234 00:33:33 0987 00:33:33 12 00:33:33 444 2.txt vvvv|ee 444|dd33|ee dddd|ee 12|ee 3ciur|fdd the output should be:

3. Shell Programming and Scripting

Using Diff to Compare 2 files

Hi I've been trying various methods that I have found online with regards to comparing 2 files using the diff command. Nothing seems to work. The problem is that I'm not too familiar with the proper syntax. Can you please assist me. Here is my script: #!/bin/bash awk -F',' -v file1="$1"...

4. Shell Programming and Scripting

awk to compare diff output by fields

Diff output as follows: < AAA BBB CCC DDD EEE 123 > PPP QQQ RRR SSS TTT 111 > VVV WWW XXX YYY ZZZ 333 > AAA BBB CCC DDD EEE 124 How can i use awk to compare the last field to determine if the counter has increased, and need to ensure that the first 4 fields must have the same...

5. Shell Programming and Scripting

compare 2 CSV fields from same diff output

Attached is a file called diff.txt It is the output from this command: diff -y --suppress-common-lines --width=5000 1.txt 2.txt > diff.txt I have also attached 1.txt and 2.txt for your convenience. Both 1.txt and 2.txt contain one very long CSV string. File 1.txt is a CSV dump of...

6. Shell Programming and Scripting

Compare two files and output in another file

I have two files ' 1st one ALIC-000352-B ALIC-000916-O DDS-STNGD FDH-PPO1-001 PFG-30601-001 2nd one 'ALIC-000352-B' 'ALIC-000916-O' 'DDS-STNGD' 'FDH-PPO1-001'

7. Shell Programming and Scripting

Compare two CSV files and put the difference in third file with line no,field no and diff value.

I am having two csv files i need to compare these files and the output file should have the information of the differences at the field level. For Example, File 1: A,B,C,D,E,F 1,2,3,4,5,6 File 2: A,C,B,D,E,F 1,2,4,5,5,6 out put file:

8. UNIX for Dummies Questions & Answers

To compare two files,Output into a new file

Hi Please help me to compare two files and output into a new file file1.txt 15114933 |4001 15291649 |933502 15764675 |4316 15764678 |4316 15761974 |282501 15673104 |933505 15673577 |933505 15673098 |933505 15673096 |933505 15673092 |933505 15760705 ...

9. Shell Programming and Scripting

Trying to use diff output to compare to a separate file

I have two files: smw:/working/iso_testing # cat a QConvergeConsoleCLI-1.1.03-49.x86_64.rpm aaa_base-13.2+git20140911.61c1681-1.3.i586.rpm acpica-20140724-2.1.2.i586.rpm test.rpm smw:/working/iso_testing # cat b QConvergeConsoleCLI-1.1.03-49.x86_64.rpm...

LEARN ABOUT OSF1

merge

merge(1)																  merge(1)

NAME

       merge - three-way file merge

SYNOPSIS

       merge [-Llabel1 [-Llabel3]] [-p] [-q] file1 file2 file3

DESCRIPTION

       merge  incorporates  all  changes that lead from file2 to file3 into file1. The result goes to standard output if -p is present, into file1
       otherwise.  merge is useful for combining separate changes to an original.  Suppose file2 is the original, and both  file1  and	file3  are
       modifications of file2. Then merge combines both changes.

       An  overlap occurs if both file1 and file3 have changes in a common segment of lines. On a few older hosts where diff3 does not support the
       -E option, merge does not detect overlaps, and merely supplies the changed lines from file3.  On most hosts, if overlaps occur, merge  out-
       puts a message (unless the -q option is given), and includes both alternatives in the result.  The alternatives are delimited as follows:

       <<<<<<< file1 lines in file1 ======= lines in file3 >>>>>>> file3

       If  there  are  overlaps,  the  user  should edit the result and delete one of the alternatives. If the -L label1 and -L label3 options are
       given, the labels are output in place of the names file1 and file3 in overlap reports.

DIAGNOSTICS

       Exit status is 0 for no overlaps, 1 for some overlaps, 2 for trouble.

IDENTIFICATION

       Author: Walter F. Tichy.
       Revision Number: 1.1.6.2; Release Date: 1993/10/07.
       Copyright (C) 1982, 1988, 1989 by Walter F. Tichy.
       Copyright (C) 1990, 1991 by Paul Eggert.

SEE ALSO

       diff3(1), diff(1), rcsmerge(1), co(1)

																	  merge(1)