Rowland, you're right on! Although there were no visible characters or spaces in each questionable field, As I pasted fresh data in each record, the active sort adjusted the them in ascending order on the fly. Hmmm, that's something I wasn't aware of either. Sweet!
Sincerest appreciation, Steve On 7/20/09 5:08 PM, "Rowland Carson" <[email protected]> wrote: > At 2009-07-20 16:43 -0400 Steve Roethel wrote: > >> all have the same street_name with the same value (no missing or >> added characters/spaces. > > Steve - either the numbers or the street names must have some funnies > hidden away somewhere. I have chased this sort of thing around for > ags with data that I KNEW was in good order, only to find in the end > that there was (eg) a carriage-return at the end of one field. I > often find that if I can't see the problem I've been looking in the > wrong place! > > I suggest you try doing an export of just these few records that you > are using as an example, exporting ONLY the fields that you are > sorting on (should be just street name & number) but including any > others if there are others in the sort order, to a tab-text file. > > Then open the file in TextWrangler or similar text editor with > fixed-width font and choose the "show invisibles" option. > > I'd be very surprised if that doesn't show some clue to the sorting > oddity, such as characters not lining up across all lines, or > unsuspected hidden characters in one or two records. If the data > entry has been done by humans, that sort of finger trouble is all too > common. > > regards > > Rowland
