This will be useful. I use Perl quite often for various utility programs.
On August 22, 2014 10:13:39 PM CDT, Paul Boniol <[email protected]> wrote: > 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 <[email protected]> > 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 [email protected] > To unsubscribe from this group, send email to > [email protected] > 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 [email protected]. > For more options, visit https://groups.google.com/d/optout. -- John F. Eldredge -- [email protected] "Darkness cannot drive out darkness; only light can do that. Hate cannot drive out hate; only love can do that." Dr. Martin Luther King, Jr. -- -- You received this message because you are subscribed to the Google Groups "NLUG" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
