Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Sort multidimensional array
#5
Solved: 12 Years, 10 Months, 3 Weeks ago
Below is the piece of code for sorting two dimensional array in vbscript. Try to execute it & should there be any concern, please let me know.

Cheers,
AB

Code:
Dim Myarr(2,2)
Myarr(0,0) = 0
Myarr(0,1) = 6
Myarr(0,2) = 5
Myarr(1,0) = 1
Myarr(1,1) = 4
Myarr(1,2) = 3
Myarr(2,0) = 2
Myarr(2,1) = 8
Myarr(2,2) = 7

Call sortArray()

Function sortArray()
    For row = 0 to UBound(Myarr, 1)
        For col = 0 To UBound(Myarr, 2)
            While Not (setRightDimension(row, col, Myarr(row, col)))
                setRightDimension row, col, Myarr(row, col)
            Wend
        Next
    Next
    Msgbox "Sorting Completed!!!"
    For i = 0 to UBound(Myarr, 1)
        For j = 0 To UBound(Myarr, 2)
            Print Myarr(i, j)
        Next
    Next
End Function


Function setRightDimension(ByVal rowNum, ByVal colNum, ByVal value1)
    Dim originalColNumber:originalColNumber = colNum
    Dim correctRow:correctRow = rowNum
    Dim correctCol:correctCol = colNum
    For rowNumber = rowNum to UBound(Myarr, 1)
        For colNumber = colNum To UBound(Myarr, 2) Step 1
            If value1 > Myarr(rowNumber, colNumber) Then
                correctRow = rowNumber
                correctCol = colNumber
            End If
        Next
        If colNumber = UBound(Myarr, 2) + 1 Then
            colNum = 0
        End If
    Next
    If rowNum <> correctRow or originalColNumber <> correctCol Then
        swap rowNum, originalColNumber, correctRow, correctCol
        setRightDimension = False
    Else
        setRightDimension = True
    End If
End Function

Function swap(ByVal oldRow, ByVal oldCol, ByVal newRow, ByVal newCol)
    Dim temp:temp = Myarr(oldRow, oldCol)
    Myarr(oldRow, oldCol) = Myarr(newRow, newCol)
    Myarr(newRow, newCol) = temp
End Function
Reply


Messages In This Thread
Sort multidimensional array - by SBsteven - 03-02-2010, 04:20 AM
RE: Sort multidimensional array - by Saket - 03-02-2010, 09:51 AM
RE: Sort multidimensional array - by SBsteven - 03-02-2010, 07:38 PM
RE: Sort multidimensional array - by Saket - 03-03-2010, 12:09 PM
RE: Sort multidimensional array - by anuj.bajaj - 03-07-2014, 04:40 PM
RE: Sort multidimensional array - by anuj.bajaj - 03-12-2014, 07:41 PM
RE: Sort multidimensional array - by anuj.bajaj - 03-14-2014, 02:49 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Get numbers inside all webelements in webtable and sort them pradeep537 1 3,284 08-04-2016, 01:24 AM
Last Post: Ankur
  sort two dimensional array. venkatesh9032 0 2,057 03-06-2014, 02:47 PM
Last Post: venkatesh9032
  how to join two multidimensional array venkatesh9032 4 4,837 02-18-2014, 12:50 PM
Last Post: venkatesh9032
  How to convert a single dimension array to two dimensional array venkatesh9032 3 6,296 02-10-2014, 03:07 PM
Last Post: pranikgarg
  Sort Order Check automation2012 2 5,188 03-26-2013, 02:54 PM
Last Post: automation2012

Forum Jump:


Users browsing this thread: 1 Guest(s)