Re: Sort and remove duplicates

At 2007-09-28 09:10AM, "JimJx" wrote:
Hi everyone,

Got what should be an easy problem.

I have a db (MySQL) that I need to sort on the first field and remove
dups from.

For example, let's say I have Red,1,2,3,4,5 and Blue,1,2,3,4,5 and
Green,1,2,3,4,5 and Green,2,2,2,2,2

How can I come out with Blue,1,2,3,4,5;Green,1,2,3,4,5;Red,1,2,3,4,5??

my %data;
while (<DATA>) {
my $field1 = (split ',')[0];
$data{$field1} = $_ unless exists $data{$field1};
}

my @non_dups = values %data;



--
Glenn Jackman
"You can only be young once. But you can always be immature." -- Dave Barry
.

Relevant Pages

  • Re: Sort and remove duplicates
    ... I have a db (MySQL) that I need to sort on the first field and remove ... dups from. ...
    (comp.lang.perl.misc)
  • Sort and remove duplicates
    ... I have a db (MySQL) that I need to sort on the first field and remove ... dups from. ...
    (comp.lang.perl.misc)
  • Re: Sort and remove duplicates
    ... I have a db that I need to sort on the first field and remove ... dups from. ... perldoc DBI ...
    (comp.lang.perl.misc)
  • Re: Event-based databases
    ... sort type indicates whether it is word for word, letter for letter, numbers ... a web site I update at times; this is a MySQL table create statement. ... KEY `sortdate` ... Somewhere I've got a copy of MySQL, but I never learnt how to use it. ...
    (soc.genealogy.computing)
  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... >select is about 100 times more powerful than spreadsheets. ... 5 point moving averages from a table ... in which the first field is observation number and the second field is ... What sort of gyrations does something this simple require in a SELECT ...
    (microsoft.public.excel)