Re: Sorting and searching

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: CLR (croberts_at_tampabay.rr.com)
Date: 12/14/04 

Date: Mon, 13 Dec 2004 19:59:46 -0500

Well, on second thought, it looks like you could forget the concatenation
part of the suggestion, and just use a fifth column, with something like

=MIN(LEFT(A2,4),RIGHT(D2,4))

(This assumes A is your "Escrow#" column and D is your "Comments" column
with the "blah blah NNNN".)

and then sort on that column as the first key and the Escrow# column as the
second key, both ascending.

Vaya con Dios,
Chuck, CABGx3

"PitchBlackSheep" <lady_une@usa.com> wrote in message
news:1102984462.287632.21660@c13g2000cwb.googlegroups.com...
> Thanks for the reply, but I'm a bit confused. I've been looking at
> this for so long that I've become slow ;) Can you explain?
> Cheers!
>
> ~ Rose
>

Relevant Pages

  • Re: Reading LAST line from text file without iterating through the file?
    ... formerly AS/400, successor to the System/3x), blah blah blah ... newline character. ... You and some others pooh-poohed that suggestion because it might not work ... I'd expect those few users will expect their quirky computers to not ...
    (comp.lang.java.programmer)
  • Re: Reading LAST line from text file without iterating through the file?
    ... formerly AS/400, successor to the System/3x), blah blah blah ... much doubt that very many people deal with them in an IT capacity. ... You and some others pooh-poohed that suggestion because it might not work ... The programs I work on run under Windows JVMs but still ...
    (comp.lang.java.programmer)
  • Re: RUTSies Nomination Form HIJACKED
    ... > sinister, something hypocritical, etc, etc, blah blah blah.. ... Do I think it's a stupid award that Dylan was ... Did I care about removing it before? ... I put the suggestion out to the group at ...
    (rec.sport.football.college)
  • Re: Looping through file for regex
    ... if output order doesn't matter. ... original code checked the first key against the file, then second, then ... Your suggestion could find the sixth index before it finds the ...
    (perl.beginners)
  • Re: Looping through file for regex
    ... > Your way is certainly better, if output order doesn't matter. ... > original code checked the first key against the file, then second, then ... Your suggestion could find the sixth index before it finds the ...
    (perl.beginners)