Juerd already did a nice script (sorry I have no ++ left for today :-( but he didn't read the Other in a, b, c, ...., y, z, 0-9, Other and I think that's what makes it complicate. 

#!/usr/bin/perl

use strict;
use CGI qw(:standard);

my $letter = param ('letter');
my @alluser;

foreach ('a' .. 'z', '0-9', 'other') {
    print a({href=>"user.pl?letter=$_"}, $_), "\n"; // change user.pl 
+if needed
}

if ($letter =~ /^[a-z]$/i) {
    while (<DATA>) {
      push (@alluser, $_) if /^$letter/i;
    } }
elsif ($letter eq '0') {
    while (<DATA>) {
      push (@alluser, $_) if /^[0-9]/i;
    } }
elsif ($letter eq "other") {
    while (<DATA>) {
      push (@alluser, $_) if /^[^a-z^A-Z^0-9]/;
    } }
else {
    while (<DATA>) {
        push (@alluser, $_);
    } }

print sort @alluser;
__DATA__
TomK32|abcdef
tye|dude
crazyinsomniac|chick
juerd|dunno
007|Bond, James
~spacecowboy|wowawa
*star*|shine

[download]
Of course tested but written w/o CGI-knowledge and ugly output™.

--
paco for president
TomK32 - just a geek trying to change the world

In reply to Re: Sorting Text DB by TomK32
in thread Sorting Text DB by skirrow

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.