Re: Sorting Question -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Probably the easiest, in my opinion, is to load the needed data into an array first, before you load the dspf. The first column of the array would be the IP address, where each quartile is forced to %exditc(wQuartile: 'X') where wQuartile is 3/0. Once the array is loaded, sorta on the array and then load the dspf directly from the array.

err... quartile... is that the right term? In any event, I mean each section of the ip address. (you'll need to do each segment since any segment can be less than 3 long. For clarity on the display, I would consider listing the ip as 192.044.208.012 instead of 192.44.208.12/

Jon S wrote:

I have the need to sort a file of IP addresses on a display as if they had a leading zero. For example they want to see

192.44.208.119 192.44.208.12 192.44.208.120
to be sorted as

192.44.208.12 192.44.208.119 192.44.208.120
as if the .12 had a leading zero. This is a character field. Any suggestions? Thanks in advance.

Jon
_________________________________________________________________
Windows 7: It helps you do more. Explore Windows 7.
http://www.microsoft.com/Windows/windows-7/default.aspx?ocid=PID24727::T:WLMTAGL:ON:WL:en-US:WWL_WIN_evergreen3:102009

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.