Re: finding duplicates in txt file

2010-11-10 Thread Rob Coops
On Wed, Nov 10, 2010 at 1:58 PM, Natalie Conte wrote: > HI, > > I have to find triplicates ProbeName $arg[8] in a txt file and > calculate a mean of their associated valueProbe $args[13] > > At the end my txt file has to contain unique probeName and valueProbe . > > This si my beginning of a sc

Re: finding duplicates in txt file

2010-11-10 Thread Chandrashekar Bhat
Can you display the contents of the file... Thanks, Chandrashekar On Wed, Nov 10, 2010 at 6:28 PM, Natalie Conte wrote: > HI, > > I have to find triplicates ProbeName $arg[8] in a txt file and > calculate a mean of their associated valueProbe $args[13] > > At the end my txt file has to cont

Re: Finding Duplicates.

2003-02-11 Thread Rob Dixon
Paul Kraus wrote: > I have to find duplicate customers in are customer file (around 60,000 > customers). > The file has been exported into a pipe delimited file. > > CustCode|Ship2Code|Name|Addr1|Addr2|City|State|ZipCode|Phone|Fax|Country > > Normally this task is done by printing it and someone go

RE: Finding Duplicates.

2003-02-11 Thread Kipp, James
> Custcode+ship2 would be unique. > > Searching just on the name wouldn't help because a lot of these > companies are fly by night and are bought and sold routinely so the > names change frequently. Ok, so we you to find dups on any field? The mispellings is going to make this tough! There are

RE: Finding Duplicates.

2003-02-11 Thread Paul Kraus
"build in" some functionality that it is lacking. -Original Message- From: Kipp, James [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 10:42 AM To: 'NYIMI Jose (BMB)'; [EMAIL PROTECTED]; Perl Subject: RE: Finding Duplicates. > > > > So you a

RE: Finding Duplicates.

2003-02-11 Thread Kipp, James
> > > > So you are looking for duplicates on any field? Wouldn't you > > just be looking for a dup on the Name? Shouldn't the CustCode > > field be unique? > > Has your company thought about importing these files into a > > relational database. Would be much faster and easier. > > This will n

RE: Finding Duplicates.

2003-02-11 Thread Paul Kraus
Perl :) -Original Message- From: Kipp, James [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 10:25 AM To: '[EMAIL PROTECTED]'; 'Perl' Subject: RE: Finding Duplicates. > I have to find duplicate customers in are customer file (around 60,000 > customers). Th

RE: Finding Duplicates.

2003-02-11 Thread NYIMI Jose (BMB)
> -Original Message- > From: Kipp, James [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 11, 2003 4:25 PM > To: '[EMAIL PROTECTED]'; 'Perl' > Subject: RE: Finding Duplicates. > > > > I have to find duplicate customers in are custo

RE: Finding Duplicates.

2003-02-11 Thread Kipp, James
> I have to find duplicate customers in are customer file (around 60,000 > customers). > The file has been exported into a pipe delimited file. > > CustCode|Ship2Code|Name|Addr1|Addr2|City|State|ZipCode|Phone|F > ax|Country > The problem is the duplicates can be misspelled meaning you can't just