Compare data - Match first column and compare second
Hi guys, looking for some help with a way to compare data in two files but with some conditions.
example,
File 1 consists of
File 2 contains
I want to be able to match the value before the comma and then compare the IP address after the comma. I want it to print the ones which are different IP's for the same site between file1 and file2. However file2 will contain more sites than listed in file1 which i dont want to include in the output.
example output would show the site2 is different between the two files (if possible print the IP's from each file which is different)
Hope this makes sense.
Thanks.
Last edited by Don Cragun; 11-25-2015 at 03:45 PM..
Reason: Add CODE tags.
Hi there all,
I am having a question.
Is it posible to compare elements of 2 different arrays?
For example I got
Array 1 | Array 2
123_abc | 123_bcd
123_bcd | 234_bcd
234_abc | 567_abc
234_bcd | 123_abc
than the match is
123_abc & 234_bcd and non of the others.
So... (3 Replies)
Dear All,
I am new to this forum and please ignore my little knowledge :p
I have two types of data (a subset is given below)
data version 1:
439798 2 1
451209 1 2
508696 2 1
555760 2 1
582757 1 2
582889 1 2
691827... (2 Replies)
Hi all,
I have 2 files:Column1 of first file has to be matched with column 3 of second file
first file contain DATA like this in 2 columns one with gene name second with whether CAD,HT,RA T2Dor any one
column 1 column2
ARFGEF2 CAD
DDEF2 CAD
PSCD3 CAD
PSCD4 CAD
CAMK1... (5 Replies)
Hello experts,
Please help me in achieving this in an easier way possible. I have 2 csv files with following data:
File1
08/23/2012 12:35:47,JOB_5330
08/23/2012 12:35:47,JOB_5330
08/23/2012 12:36:09,JOB_5340
08/23/2012 12:36:14,JOB_5340
08/23/2012 12:36:22,JOB_5350
08/23/2012... (5 Replies)
Hi..
In the below sorted input file.. I am comparing the first 3 columns of data one by one row and it is a pipeline delimitter file..
AA|BB|CC|line1
AA|BB|CC|ine4
AA|BB|CC|line2
BB|CC|DD|line3
BB|CC|DD|line5
If first 3 columns of data matches with any record in the file the... (4 Replies)
Hi,
I need to compare 2 text files with around 60000 rows and 1 column. I need to compare these and write the mismatch data to 3rd file.
File1 - file2 = file3
wc -l file1.txt
58112
wc -l file2.txt
55260
head -5 file1.txt
101214200123
101214700300
101250030067
101214100500... (10 Replies)
Hi, I am newbie in shell script.
I need your help to solve my problem.
Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file.
File1:
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
I am working on an outage script and I run a command from the command line which tells me the amount of generator failures in my market. The output of this command only gives me three digits to identify the site by. I have a master list of all sites in a separate file, call it list.txt. If my... (7 Replies)
Example:
I have files in below format
file 1:
zxc,133,joe@example.com
cst,222,xyz@example1.com
File 2 Contains:
hxd
hcd
jws
zxc
cst
File 1 has 50000 lines and file 2 has around 30000 lines :
Expected Output has to be :
hxd
hcd
jws (5 Replies)
hi
I have 2 file with more than 10 columns for both
1st file
apple,0,0,0......
orange,1,2,3.....
mango,2,4,5.....
2nd file
apple,2,3,4,5,6,7...
orange,2,3,4,5,6,8...
watermerlon,2,3,4,5,6,abc...
mango,5,6,7,4,6,def.... (1 Reply)
Discussion started by: tententen
1 Replies
LEARN ABOUT DEBIAN
chdist
CHDIST(1)CHDIST(1)NAME
chdist - script to easily play with several distributions
SYNOPSIS
chdist [options] [command] [command parameters]
DESCRIPTION
chdist is a rewrite of what used to be known as 'MultiDistroTools' (or mdt). Its use is to create 'APT trees' for several distributions,
making it easy to query the status of packages in other distribution without using chroots, for instance.
OPTIONS -h, --help
Provide a usage message.
-d, --data-dir DIR
Choose data directory (default: $HOME/.chdist/).
-a, --arch ARCH
Choose architecture (default: `dpkg --print-architecture`).
--version
Display version information.
COMMANDS
create DIST [URL RELEASE SECTIONS]
Prepare a new tree named DIST
apt-get DIST <update|source|...>
Run apt-get inside DIST
apt-cache DIST <show|showsrc|...>
Run apt-cache inside DIST
apt-rdepends DIST [...]
Run apt-rdepends inside DIST
src2bin DIST SRCPKG
List binary packages for SRCPKG in DIST
bin2src DIST BINPKG
List source package for BINPKG in DIST
compare-packages DIST1 DIST2 [DIST3, ...]
compare-bin-packages DIST1 DIST2 [DIST3, ...]
List versions of packages in several DISTributions
compare-versions DIST1 DIST2
compare-bin-versions DIST1 DIST2
Same as compare-packages/compare-bin-packages, but also runs dpkg --compare-versions and display where the package is newer.
compare-src-bin-packages DIST
Compare sources and binaries for DIST
compare-src-bin-versions DIST
Same as compare-src-bin-packages, but also run dpkg --compare-versions and display where the package is newer
grep-dctrl-packages DIST [...]
Run grep-dctrl on *_Packages inside DIST
grep-dctrl-sources DIST [...]
Run grep-dctrl on *_Sources inside DIST
list
List available DISTs
COPYRIGHT
This program is copyright 2007 by Lucas Nussbaum and Luk Claes. This program comes with ABSOLUTELY NO WARRANTY.
It is licensed under the terms of the GPL, either version 2 of the License, or (at your option) any later version.
Debian Utilities 2013-12-23 CHDIST(1)