Re: Numeric sorting of addresses

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

From: KiwiBrian (briantoz_at_ihug.co.nz)
Date: 10/11/04 

Date: Tue, 12 Oct 2004 08:51:31 +1300

"Don Guillett" wrote

> The street will not be ignored unless in a separate column
> 1 aa
> 1234 ff
> 567 dd
> 89 jj

> "KiwiBrian" wrote

>> How do I sort on a column of addresses so that e.g.:-
>> 1234 567 89 1
>> Would be sorted as:-
>> 1 89 567 1234
>>
>> Each entry has the street name following the numeric but these can be
>> ignored in the sorting criteria.

Hi Don.
I thank you for your reply but it was a bit too cryptic for me.
Can you enlarge on what you are illustrating please?

In my specific situation, as I have already successfully extracted all
entries for a particular street from the main database, the alpha text in
each case is identical, and only the numeric portion is different.
So I have the first entry as 1 Foo St and the second entry is 1007 Foo St
and many more entries before coming to 2 Foo St.
I hope this clarifies my situation and problem.

Thanks
Brian Tozer

Relevant Pages

  • Re: Can I find the last value in a column of cells?
    ... Microsoft Excel MVP ... "Don Guillett" wrote in message ... some columns might have more or less entries than another column. ... I want to find the bottom entry in the list, regardless of what row that entry is in and return the value of that entry please? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: KMail mailing list
    ... Timothy Murphy wrote: ... Now Foo appears as an entry in the contacts list, ... Double clicking on Foo opens a small window, ...
    (Fedora)
  • Re: Can I find the last value in a column of cells?
    ... "Don Guillett" wrote in message ... "Chris" wrote in message ... some columns might have more or less entries than another column. ... I want to find the bottom entry in the list, regardless of what row that entry is in and return the value of that entry please? ...
    (microsoft.public.excel.worksheet.functions)
  • Debug tasks spawned by taskSpawn
    ... Wind River Workbench 2.4 with vxWorks 6.2. ... When I try to debug this project, how can I debug the function foo() ... I need to see who overwrite the global variables inside fooat the ... If i set the entry point to be mainwith "break on entry" checked, ...
    (comp.os.vxworks)
  • Re: Regex find and replace - delete line
    ... If you want to delete entries from @file completely... ... that _equal_ to 'foo' (and the entry does not contain a line ending): ... If I'm missing something, I blame the fact that it's only six in the ...
    (perl.beginners)