Re: Attn: Marshall Barton

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

On Thu, 27 Sep 2007 12:38:23 -0500, Marshall Barton <marshbarton@xxxxxxxxxx>
wrote:

Chuck wrote:

Due to the nature of the part numbers we are working with, parsing them left,
center, right did not make any difference in the sort order. Your milage may
vary for part numbers with different formats.


I came very close a month ago, but there are some part
numbers did not fit the simple parsing rules I used. As I
see the problem, the trick is to identify which characters
are in the left, middle and right portions given the
apparently ambiguous mix of alphas, digits, the dot/dash and
the fact that each portion can vary from 0 to 6 characters.
There's even one example where the middle portion is not all
digits. It's enough to give me a headache, but intriguing
in a twisted sort of way.

You can: find first number, find first character, find first number after first
character, find first character after first number after first character, ...

Sort left, left mid, mid, right mid, right.

I think we are gilding the lily.

Chuck --

.

Relevant Pages

  • Re: How to sort a list of strings on a substring
    ... No, that's incorrect. ... Try it with this data and you will see it fails: ... *not* how to sort the list according to the first character '1'. ...
    (comp.lang.python)
  • Re: Attn: Marshall Barton
    ... right did not make any difference in the sort order. ... find first number, find first character, find first number after first ... I think we are gilding the lily. ... the right mid if some other portions are missing. ...
    (microsoft.public.access.reports)
  • Re: Attn: Marshall Barton
    ... right did not make any difference in the sort order. ... find first number, find first character, find first number after first ... I think we are gilding the lily. ... the right mid if some other portions are missing. ...
    (microsoft.public.access.reports)
  • Re: sort with special order
    ... >>> I need to sort them so they are in order of Q, B, then Z>>> ... select the first character of the string and prepend ...
    (perl.beginners)
  • Re: Anti - Muslim ignorance
    ... the sort of time necessary to type out an adequate response. ... demonstrate a divine origin of the Qur'an. ... Another portion worthy of note is the following commentary on Soorat ...
    (alt.religion.islam)