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 values, e.g. in the example above, the counter field has increased by 1 count for "AAA BBB CCC DDD EEE" entry.
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 values, e.g. in the example above, the counter field has increased by 1 count for "AAA BBB CCC DDD EEE" entry.
...
So if the diff output is like so -
then should the counter be -
(a) 3, because "AAA BBB CCC DDD EEE" incremented 3 times?, or
(b) 2, because "PPP QQQ RRR SSS TTT" incremented 2 times?, or
(c) 1, because "VVV WWW XXX YYY ZZZ" incremented once?, or
(d) 0, because "GGG HHH III JJJ KKK" did not increment at all?
Thanks for the reply. I think I've confused some of us including myself. Let me try this again:
Diff output has this:
need some awk help to:
- scan the lines and compare the first 5 fields of each line
- and when all 5 fields match, then compare the 6th field (i.e. counter) to check if the value has increased or decreased
- if the counter value has increased, do something
- else, do nothing
- if scan cannot find line with matching first 5 fields, then do something
- end of scan
Thanks again in advance.. my apologies for the confusion.
Last edited by vgersh99; 11-10-2010 at 01:20 PM..
Reason: code tags, please!
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... (12 Replies)
Hello experts!
I have 2 files.
file1 is a list file containing uniquely names. e.g.:
name1 number number
name2 number number
name5 number number
name10 number number
...
file2 is a data file arbitrary containing the names of file1 in paragraphs separated by "10" e.g.
name4 ... (3 Replies)
I'm trying to compare 2 files for differences in a selct number of fields. When differnces are found it will write the whole record of the second file including appending '|C' out to a delta file. Each record will have 20 fields, but only want to do comparison of 1st 15 fields. The 1st field of... (7 Replies)
Hi all !
If there is only one single value in a column (e.g. column 1 below), then return this value in the same output column.
If there are several values in the same column (e.g. column 2 below), then return the different values separated by "," in the output.
pipe-separated input:
... (11 Replies)
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... (0 Replies)
Hi All,
Looking for a quick AWK script to output some differences between two files.
FILE1
device1 1.1.1.1 PINGS
device1 2.2.2.2 PINGS
FILE2
2862 SITE1 device1-prod 1.1.1.1 icmp - 0 ... (4 Replies)
Hi unix gurus,
I have a urgent requirement, I need to write a AWK script to compare each fields in 2 files using AWK.
Basically my output should be like this.
file1
row|num1|num2|num3
1|one|two|three
2|one|two|three
file2
row|num1|num2|num3
1|one|two|three
2|one|two|four
... (5 Replies)
Need a script that manipulates a fixed length file that will compare 2 fields in that file and if they are equal write that line to a new file.
i.e. If fields 87-93 = fields 119-125, then write the entire line to a new file. Do this for every line in the file. After we get only the fields... (1 Reply)
Hi,
My first post to this group...
I have a need to to parse a source file which is a capture from a network analyser.
I have two fields that need to be checked:
- Field 7 represents the packet length (an integer), and
Field 4 represents a network address (e.g. 192.168.25.3)
- The... (10 Replies)
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.
# !/usr/bin/bash
#
# NoInterfaces
# Utility will create a file... (8 Replies)