Shell Programming and Scripting

Hi,

i need to display the mismatches from two files.The output what is get is the entire rows which mismatch from file 1 are displayed first and the corresponding rows from file 2 are displayed below it.

Sample output:

From Test Run 1 - The row count of file2.txt is 23
From Test Run 1 - The row count of file3.txt is 20
From Test Run 1 - The row count of file4.txt is 2
From Test Run 2 - The row count of file2.txt is 22
From Test Run 2 - The row count of file3.txt is 21
From Test Run 2 - The row count of file4.txt is 1

Code used is:
diff -bi 21.txt 22.txt > 13.txt
sed -e '/^-/d' -e '/^[1-9]/d' -e 's/^[<>] //' 13.txt >> ab.out

how can the ouput be displayed this way?

From Test Run 1 - The row count of file4.txt is 2
From Test Run 2 - The row count of file4.txt is 1
From Test Run 1 - The row count of file2.txt is 23
From Test Run 2 - The row count of file2.txt is 22
From Test Run 1 - The row count of file3.txt is 20
From Test Run 2 - The row count of file3.txt is 21

Try to provide the input sample.

The first file will contain the row count of the files in directory one.

e.g.
A The row count of file2.txt is 23
A The row count of file3.txt is 20
A The row count of file4.txt is 2

The second file will contain the row count of the files in directory two.
e.g.
a The row count of file2.txt is 22
a The row count of file3.txt is 21
a The row count of file4.txt is 1

I am comparing the files ignoring the case and spacing difference.

Finally after comparing i am replacing 'A' with "From Test Run 1 - " and 'a' with "From Test Run 2 - ".

Hi,

Can anyone help me on this?

Please don't bump posts.

I don't think diff is the right tool here. Can't you just sort on the file name field, and pipe to a simple awk script which compares the last field, and prints as necessary?

Hi era,

I do not know much of scripting.Can you give me a awk script to compare files after sorting which should ignore spacing difference and case and the line which mismatches from file 2 with that of file 1 should be displayed one below the other?

For e.g.

File 1 contains

A The row count of file2.txt is 23
A The row count of file3.txt is 20
A The row count of file4.txt is 2

File 2 contains

a The row count of file2.txt is 22
a The row count of file3.txt is 21
a The row count of file4.txt is 1

Output should be like

A The row count of file2.txt is 23
a The row count of file2.txt is 22
A The row count of file3.txt is 20
a The row count of file3.txt is 21
A The row count of file4.txt is 2
a The row count of file4.txt is 1

Will awk be able to compare files of size 20MB?

Assuming you don't have spaces in the file names or other oddities not visible in your examples, try something like this.

Code:

sort -k10 21.txt 22.txt |
awk '$10 == prevfile && $12 != prevsize { print prev; print }
{ prevfile = $10; prevsize=$12; prev=$0 }'

This will print the results for file2.txt then file3.txt then file4.txt etc. If that is a problem then you can sort the output from awk (add | sort -k4 at the very end).

Sorting causes the lines with the same filenn.txt to be adjacent:

Code:

vnix$ cat >21.txt
From Test Run 1 - The row count of file2.txt is 23
From Test Run 1 - The row count of file3.txt is 20
From Test Run 1 - The row count of file4.txt is 2
vnix$ cat >22.txt
From Test Run 2 - The row count of file2.txt is 22
From Test Run 2 - The row count of file3.txt is 21
From Test Run 2 - The row count of file4.txt is 1
vnix$ LC_ALL=C sort -k10 21.txt 22.txt
From Test Run 2 - The row count of file2.txt is 22
From Test Run 1 - The row count of file2.txt is 23
From Test Run 1 - The row count of file3.txt is 20
From Test Run 2 - The row count of file3.txt is 21
From Test Run 2 - The row count of file4.txt is 1
From Test Run 1 - The row count of file4.txt is 2

The LC_ALL is because the sort order in my locale is different from the default; you might need to add that, too.

Now we only need to check if filennn.txt is the same as on the previous line, and if so, if the row count is different; if so, we print both the previous line and this one. Then we take care to remember the file name, the row count, and the whole line so that the comparison can take place again when the next line comes in.

This reads one line at a time, so doesn't use more memory for bigger files. The sort will be a bottleneck, though, obviously.