Re: Sort and remove duplicates


Quoth JimJx <webmaster@xxxxxxxxxxxxxxxx>:
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??

I know that there is a simple way to do this but my brain is not
functioning right now.

perldoc DBI
perldoc -q duplicate
(possibly perldoc -f sort as well)

When you've had a go, post your code and we'll help you fix it.

Ben

.

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)
  • 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: order a semicolon-separated data file by a value of a column
    ... >>My suggestion would be to read each element, store each line in an array ... >>reference, store each reference in a larger array, sort the array by the ... type 'perldoc ... > references, I read the lama book and it does't mention references. ...
    (comp.lang.perl.misc)
  • 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)