Hi Steve,
If you put spaces in front of the numbers (eg ^^1,^^2,^11 etc. where ^
represents a space) the sort seems to do what you want - ie gives
1
2
3
10
11
100
followed by any alphabetic stuff.
You're going to need to know the maximum number of digits in your road
numbers (eg if there are four digits, then pad out the numbers to four chars
using leading spaces). You may even be able to do it automatically using an
update column statement, if you can isolate the numeric streets, that is.
Hope this helps - at any rate it's got to be better than the "use order by"
suggestions you seem to have got so far!
Dave.
---------------------------------------------
David Booth
Senior GIS Officer
Merseyside Information Service
> -----Original Message-----
> From: Morrier, Steve [SMTP:[EMAIL PROTECTED]]
> Sent: 26 April 2001 19:46
> To: MapInfo List (E-mail)
> Subject: MI-L Sorting
>
> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
>
>
> Sorry,
>
> I should have specified that I am sorting street files and the column
> contains highways that must be displayed as numbers. So converting my
> field
> from character to integer is not an option. Thanks for everyones help.
>
> Steve
>
>
> Original Question:
>
> Is there any way to get MapInfo to sort numerically? i.e.
> 1,2,3,4,5,34,78,100
> instead of 1,10, 100, 2, 20, etc...
>
>
>
>
> _______________________________________________________________________
> List hosting provided by Directions Magazine | www.directionsmag.com |
> To unsubscribe, send e-mail to [EMAIL PROTECTED] and
> put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
