Re: [nlug] Perl Name Sort

2014-08-22 Thread Paul Boniol
That did it! :)  At least it ignores the apostrophe, and set it to ignore
accents (I don't think we have any names with them, but you never know.when
that might happen.)

I'm still familiarizing myself with the parameters, but this code seems to
be pretty much what I want.

my $coll = Unicode::Collate->new(locale => 'en_US', normalization => undef,
level => 1);

Looping over the rows of data:
$row->{SortKey1} = $coll->getSortKey($row->{LastName});
$row->{SortKey2} = $coll->getSortKey($row->{FirstName});
$row->{SortKey3} = $coll->getSortKey($row->{MiddleNames});

Paul


On Fri, Aug 22, 2014 at 7:01 PM, Brian Pitts  wrote:

>  You may want Unicode::Collate:Locale
>
> http://search.cpan.org/~sadahiro/Unicode-Collate-1.07/Collate/Locale.pm
>
> http://www.perl.com/pub/2012/06/perlunicook-unicode-locale-collation.html
>
>
> On 08/22/2014 06:34 PM, Paul Boniol wrote:
>
> I know there must be some Perl module out there I'm overlooking. I need to
> sort data by name.  According to the Chicgo Manual of Style / US Phone
> book, you don't do just a normal sort.
>
>  E.g.  O'Reilly is treated as OReilly (case insensitive).
>
>  (Some variations say last names starting with Mc should be treated as
> Mac.  And St. Andrew should be Saint Andrew.  Etc.  I'm not as worried
> about those.)
>
>  I've found all sorts of things for sorting in different languages,
> German phone book (umlats treated as letter and appending e).  But there
> wasn't a US phone book module.
>
>  I know there must be some common method / module for sorting names.  My
> Google foo just can't seem to find it.
>
>  I've usually just been doing a plain sort of uppercased name.  This is
> okay, no one has complained.  But I thought there must be a more proper way.
>
>  Paul
>
>
> --
> All the best,
> Brian Pitts
>
>

-- 
-- 
You received this message because you are subscribed to the Google Groups 
"NLUG" group.
To post to this group, send email to nlug-talk@googlegroups.com
To unsubscribe from this group, send email to 
nlug-talk+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/nlug-talk?hl=en

--- 
You received this message because you are subscribed to the Google Groups 
"NLUG" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to nlug-talk+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [nlug] Perl Name Sort

2014-08-22 Thread Brian Pitts

You may want Unicode::Collate:Locale |||

|||http://search.cpan.org/~sadahiro/Unicode-Collate-1.07/Collate/Locale.pm

http://www.perl.com/pub/2012/06/perlunicook-unicode-locale-collation.html

On 08/22/2014 06:34 PM, Paul Boniol wrote:
I know there must be some Perl module out there I'm overlooking. I 
need to sort data by name.  According to the Chicgo Manual of Style / 
US Phone book, you don't do just a normal sort.


E.g.  O'Reilly is treated as OReilly (case insensitive).

(Some variations say last names starting with Mc should be treated as 
Mac.  And St. Andrew should be Saint Andrew.  Etc.  I'm not as worried 
about those.)


I've found all sorts of things for sorting in different languages, 
German phone book (umlats treated as letter and appending e).  But 
there wasn't a US phone book module.


I know there must be some common method / module for sorting names. 
 My Google foo just can't seem to find it.


I've usually just been doing a plain sort of uppercased name.  This is 
okay, no one has complained.  But I thought there must be a more 
proper way.


Paul



--
All the best,
Brian Pitts

--
--
You received this message because you are subscribed to the Google Groups 
"NLUG" group.
To post to this group, send email to nlug-talk@googlegroups.com
To unsubscribe from this group, send email to 
nlug-talk+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/nlug-talk?hl=en

--- 
You received this message because you are subscribed to the Google Groups "NLUG" group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to nlug-talk+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[nlug] Perl Name Sort

2014-08-22 Thread Paul Boniol
I know there must be some Perl module out there I'm overlooking. I need to
sort data by name.  According to the Chicgo Manual of Style / US Phone
book, you don't do just a normal sort.

E.g.  O'Reilly is treated as OReilly (case insensitive).

(Some variations say last names starting with Mc should be treated as Mac.
 And St. Andrew should be Saint Andrew.  Etc.  I'm not as worried about
those.)

I've found all sorts of things for sorting in different languages, German
phone book (umlats treated as letter and appending e).  But there wasn't a
US phone book module.

I know there must be some common method / module for sorting names.  My
Google foo just can't seem to find it.

I've usually just been doing a plain sort of uppercased name.  This is
okay, no one has complained.  But I thought there must be a more proper way.

Paul

-- 
-- 
You received this message because you are subscribed to the Google Groups 
"NLUG" group.
To post to this group, send email to nlug-talk@googlegroups.com
To unsubscribe from this group, send email to 
nlug-talk+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/nlug-talk?hl=en

--- 
You received this message because you are subscribed to the Google Groups 
"NLUG" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to nlug-talk+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[nlug] Re: annual computer recycling event?

2014-08-22 Thread Chris McQuistion
Thanks for the reminder, Howard.

I've sent an email to my contact at the recycling company (Green Earth
Recycling).  I'm sure we'll get a recycling event set up soon.  I'll post
it to this list, once I know the dates.

Chris


On Thu, Aug 21, 2014 at 6:06 PM, Howard White  wrote:

> Chris,
>
> Just wondering if you have your annual computer recycling day scheduled.
> My office is getting stacked up with even more relics, to say nothing of my
> basement.
>
> HELP!!
>
> :)
>
> Howard
>

-- 
-- 
You received this message because you are subscribed to the Google Groups 
"NLUG" group.
To post to this group, send email to nlug-talk@googlegroups.com
To unsubscribe from this group, send email to 
nlug-talk+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/nlug-talk?hl=en

--- 
You received this message because you are subscribed to the Google Groups 
"NLUG" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to nlug-talk+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [nlug] annual computer recycling event?

2014-08-22 Thread Paul Boniol
The last information I could find online about a Vanderbilt / Dell
sponsored recycling event was 2008.  It seemed to have been replaced by
Nashville E-Waste event held at LP field (last information found was
November 2012).  At the end of the spring semester, there are designated
computer recycling areas outside some Vanderbilt residence halls (intended
for students, not mass disposal by businesses; Spring 2014: main campus
April 22 - May 10; Peabody Commons April 22 - May 3).

Paul

On Thu, Aug 21, 2014 at 11:25 PM, Jack Coats  wrote:

> There's a place in Joelton that takes computers.  They charge $15/ea for
> monitors or TVs.  They used to take them for free but they couldn't find a
> place where they could get them recycled profitably taking them for free.
>  (Evidently they take the TV tubes to a place in Alabama and get little for
> the glass.  It is pretty hard to separate the copper from the tube safely
> to make that part profitable.)  I think they are EPA certified.
>
> Also, I think Vandy has a recycle day, just don't remember when it is
> either.
>
>
> On Thu, Aug 21, 2014 at 6:06 PM, Howard White  wrote:
>
>> Chris,
>>
>> Just wondering if you have your annual computer recycling day scheduled.
>> My office is getting stacked up with even more relics, to say nothing of my
>> basement.
>>
>> HELP!!
>>
>> :)
>>
>> Howard
>>
>>
>
> --
> ><> ... Jack
>
> "Whatever you do, work at it with all your heart"... Colossians 3:23
> "If you are not part of the solution, you are part of the precipitate" -
> Henry J. Tillman
> "Anyone who has never made a mistake, has never tried anything new." -
> Albert Einstein
> "You don't manage people; you manage things. You lead people." - Admiral
> Grace Hopper, USN
> "a nanosecond is the time it takes electrons to propigate 11.8 inches" - "
> - http://youtu.be/JEpsKnWZrJ8
> "Life is complex: it has a real part and an imaginary part." - Martin Terma
>

-- 
-- 
You received this message because you are subscribed to the Google Groups 
"NLUG" group.
To post to this group, send email to nlug-talk@googlegroups.com
To unsubscribe from this group, send email to 
nlug-talk+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/nlug-talk?hl=en

--- 
You received this message because you are subscribed to the Google Groups 
"NLUG" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to nlug-talk+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.