Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

# sort array in descending order

Posted on 2006-11-29
Medium Priority
314 Views
Hello Experts,

I'm struggling to find a workaround to sort a numeric array in  descending order. Here is what I could compile from searching the web:

<%

iArray = ("62|37|37|100|37|37|37|37|100|37")
percArray = split(iArray,"|")
max = UBound(percArray)

For iLoop = 0 to max
For j = iLoop + 1 to max
if percArray(iLoop) > percArray(j) then
TempVar = percArray(iLoop)
percArray(iLoop) = percArray(j)
percArray(j) = TempVar
end if
next
next

For iLoop = 0 to max
Response.Write percArray(iLoop) & "<br>"
next

%>

For some reason this isn't working, I tried percArray(iLoop) > percArray(j) AND percArray(iLoop) < percArray(j). Still the numbers don't get sorted in descending order. Can anyone suggest or maybe correct this function ?

thanks
0
Question by:pazan
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 52

Accepted Solution

Carl Tawn earned 1200 total points
ID: 18037130
Try:

<%

iArray = ("62|37|37|100|37|37|37|37|100|37")
percArray = split(iArray,"|")
max = UBound(percArray)

For iLoop = 0 to max
For j = iLoop + 1 to max
if CInt(percArray(iLoop)) < CInt(percArray(j)) then
TempVar = percArray(iLoop)
percArray(iLoop) = percArray(j)
percArray(j) = TempVar
end if
next
next

For iLoop = 0 to max
Response.Write percArray(iLoop) & "<br>"
next

%>
0

LVL 28

Expert Comment

ID: 18037150
This should be exactly what you want:

http://www.evolt.org/node/21724
0

LVL 28

Expert Comment

ID: 18037166
QuickSort is a quick and reliable sorting algorithm, but if you have a small array I would probably recommend insertion sort: http://www.freevbcode.com/ShowCode.asp?ID=157
0

Author Comment

ID: 18037217
strickdd , I read that page(evolt) earlier. There's a huge script, maybe one day if I will have some problems with my existing script I will migrate to Quicksort.

carl_tawn, that works nicely, Cint did the job :)

thanks, I will give points to carl_tawn, since he corrected existed script.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:   The Exchange of informatio…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
###### Suggested Courses
Course of the Month9 days, left to enroll