Thank you rudiC and Aksay for such a quick reply..
Yes, the files are case sensitive and I did a typo mistake..
Now the actual issue over here is file 1 will have 20 million records and file 2 will have 30 thousand records... So will it cause performance issue if we go with this comparison?
Earlier I have achieved this with two while loops however it took hell lot of time. So now came to awk part.. Actually the if condition will be checking like below..
Dear all,
I have two files in UNIX File1 and File2 as below:
File1:
1,1234,.,67.897,,0
1,4134,.,87.97,,4
0,1564,.,97.8,,1
File2:
2,8798,.,67.897,,0
2,8879,.,77.97,,4
0,1564,.,97.8,,1
I want to do the following:
(1) Make sure that both the files have equal number of columns and if... (1 Reply)
Dear all,
I have two files in UNIX File1 and File2 as below:
File1:
1,1234,.,67.897,,0
1,4134,.,87.97,,4
0,1564,.,97.8,,1
File2:
2,8798,.,67.897,,0
2,8879,.,77.97,,4
0,1564,.,97.8,,1
I want to do the following:
(1) Make sure that both the files have equal number of columns and if... (4 Replies)
Hey,
I have 2 files that have a name and then a number:
File 1:
dog 21
dog 24
cat 33
cat 27
dog 76
cat 65
File 2:
dog 109
dog 248
cat 323
cat 207
cat 66 (2 Replies)
Hi,
I have two files with the same number of columns. Basically I want to print the 2 columns that match between the two files.
File1 looks like this:
dr12 12 6 abn
dr14 12 7 abn
File2 looks something like this:
dr12 12 8 abn
dr12 14 7 abn
So basically if the first... (1 Reply)
Hi Guyz
The 1st column of the input file has repeated keys like x,y and z.
The ist task is if the 1st column has unique key (say x) and then need to consider 4th column, if it is + symbol then subtract 2nd column value with 3rd column value (we will get 2(10-8)) or if it is - symbol subtract 3rd... (3 Replies)
Hi,
I have two files. File1.txt has 2 columns and looks like:
458739 122345
4456 122657
34200 122600
File2.txt has many columns with column 1 the same as column2 of File1.txt, but with lot more rows:
122786 abcdefg user1@email
122778 uuhjeufh user2@email... (1 Reply)
Hello,
I have two files as 1.txt and 2.txt with number as columns.
1.txt
0 53.7988
1 -30.0859
2 20.1632
3 14.2135
4 14.6366
5 -37.6258
.
.
.
31608 -8.57333
31609 -2.58554
31610 -24.2857
2.txt (1 Reply)
Hi,
I have a single-column file1 having records like:
00AB01/11
43TG22/00
78RC09/34
......
......
and a second file , file 2 having two columns like
78RC09/34 1
45FD11/11 2
00AB01/11 3
43TG22/00 4
......
...... (8 Replies)
Hi, I'm trying to use awk arrays to compare values across two files based on multiple columns. I've attempted to load file 2 into an array and compare with values in file 1, but success has been absent. If anyone has any suggestions (and I'm not even sure if my script so far is on the right lines)... (4 Replies)
Hello All;
I have two files with below conditions:
1. Entries in file A is missing in file B (primary is field 1)
2. Entries in file B is missing in file A (primary is field 1)
3. Field 1 is present in both files but Field 2 is different.
Example Content:
File A
... (4 Replies)
Discussion started by: mystition
4 Replies
LEARN ABOUT DEBIAN
sc_tracediff
SC_TRACEDIFF(1) BSD General Commands Manual SC_TRACEDIFF(1)NAME
sc_tracediff -- display traceroute paths where the path has changed.
SYNOPSIS
sc_tracediff [-a] [-m method] [-n] file1.warts file2.warts
DESCRIPTION
The sc_tracediff utility displays pairs of traceroutes to a destination where the path has changed. It takes two warts files as input and
displays paths where a hop differs by its address. The options are as follows:
-a dump all traceroute pairs regardless of whether they have changed.
-m method
specifies the method used to match pairs of traceroutes together. If dst is specified, traceroutes are matched if the destination IP
address of both traces are the same. If userid is specified, traceroutes are matched if the userid field of both traces are the
same. If dstuserid is specified, traceroutes are matched if the destination IP address and userid fields are the same. By default,
the destination IP address is used.
-n names should be reported instead of IP addresses, where possible.
sc_tracediff can be useful in network monitoring to identify when a forward IP path has changed. In this scenario, it is recommended that
Paris traceroute is used with the same UDP source and destination ports for each execution of scamper so that only paths that have changed
are identified, not merely alternate paths visible due to per-flow load-balancing. By default scamper uses a source port based on the
process ID, which will change with each execution of scamper.
EXAMPLES
The command:
scamper -O warts -o file1.warts -c 'trace -P udp-paris -s 31337' -f list.txt
collects the forward IP paths towards a set of IP addresses found in list.txt using 31337 as the UDP source port value. If the above command
is adjusted to subsequently collect file2.warts, then we can identify paths that have subsequently changed with the command:
sc_tracediff file1.warts file2.warts
If Paris traceroute with ICMP probes is preferred, then the following invocation of scamper is appropriate:
scamper -O warts -o file1.warts -c 'trace -P icmp-paris -d 31337' -f list.txt
In this case, scamper uses 31337 as the ICMP checksum value in each probe.
SEE ALSO scamper(1),
B. Augustin, X. Cuvellier, B. Orgogozo, F. Viger, T. Friedman, M. Latapy, C. Magnien, and R. Teixeira, Avoiding traceroute anomalies with
Paris traceroute, Proc. ACM/SIGCOMM Internet Measurement Conference 2006.
AUTHOR
sc_tracediff is written by Matthew Luckie <mjl@luckie.org.nz>.
BSD April 21, 2011 BSD