Remove Nothing values ​​from multidimensional arrays

Question

How to remove values ​​from "Nothing" and reduce the array to values ​​that have values?

says i have a 2 dimensional array called modvaluestmp(,). I used the following linq statement to not delete anything. It worked, but the resulting array (result) is a one-dimensional array. Can someone help me return a 2D array storing indexes?

Dim result() = (From str In modvaluestmp
              Where Not {Nothing}.Contains(str)).ToArray()

an existing array looks something like this:

modvaluestmp(0,0) = "sometext1"
modvaluestmp(0,1) = "sometext2"
modvaluestmp(0,2) = "sometext3"
modvaluestmp(0,3) = "sometext4"
modvaluestmp(0,4) = Nothing
modvaluestmp(0,5) = Nothing
modvaluestmp(1,0) = "sometext5"
modvaluestmp(1,1) = "sometext6"
modvaluestmp(1,2) = "sometext7"
modvaluestmp(1,3) = "sometext8"
modvaluestmp(1,4) = Nothing
modvaluestmp(1,5) = Nothing

I want the array to look like this

modvaluestmp(0,0) = "sometext1"
modvaluestmp(0,1) = "sometext2"
modvaluestmp(0,2) = "sometext3"
modvaluestmp(0,3) = "sometext4"
modvaluestmp(1,0) = "sometext5"
modvaluestmp(1,1) = "sometext6"
modvaluestmp(1,2) = "sometext7"
modvaluestmp(1,3) = "sometext8"

Answer 1

You have to use jagged-arrayinstead of a square a 2D array. Therefore, your codes should look like this:

 Dim modvaluestmp = New String(1)() {}

 modvaluestmp(0) = New String(5) {}
 modvaluestmp(1) = New String(5) {}

 modvaluestmp(0)(0) = "sometext1"
 modvaluestmp(0)(1) = "sometext2"
 modvaluestmp(0)(2) = "sometext3"
 modvaluestmp(0)(3) = "sometext4"
 modvaluestmp(0)(4) = Nothing
 modvaluestmp(0)(5) = Nothing
 modvaluestmp(1)(0) = "sometext5"
 modvaluestmp(1)(1) = "sometext6"
 modvaluestmp(1)(2) = "sometext7"
 modvaluestmp(1)(3) = "sometext8"
 modvaluestmp(1)(4) = Nothing
 modvaluestmp(1)(5) = Nothing

 Dim result = (From ary In modvaluestmp Select ary.Where(Function(str) Not str Is Nothing).ToArray()).ToArray()

Help links:

MSDN

Answer 2

, :

• trailing
• , (, )

, , ReDim Preserve:

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
    Dim modvaluestmp(,) As String = {
        {"sometext1", "sometext2", "sometext3", "sometext4", Nothing, Nothing},
        {"sometext5", "sometext6", "sometext7", "sometext8", Nothing, Nothing},
        {"sometext9", "sometext10", Nothing, Nothing, Nothing, Nothing}
    }

    Console.WriteLine(DisplayArray(modvaluestmp))

    Dim max As Integer = modvaluestmp.GetUpperBound(1)
    For y As Integer = 0 To modvaluestmp.GetUpperBound(0)
        For x As Integer = modvaluestmp.GetUpperBound(1) To 0 Step -1
            If Not IsNothing(modvaluestmp(y, x)) AndAlso x < max Then
                max = x
                Exit For
            End If
        Next
    Next

    ReDim Preserve modvaluestmp(modvaluestmp.GetUpperBound(0), max)
    Console.WriteLine(DisplayArray(modvaluestmp))
End Sub

Private Function DisplayArray(ByVal arr(,) As String) As String
    Dim sb As New System.Text.StringBuilder
    For y As Integer = 0 To arr.GetUpperBound(0)
        For x As Integer = 0 To arr.GetUpperBound(1)
            sb.Append(If(x = 0, "", ", ") & arr(y, x))
        Next
        sb.AppendLine("")
    Next
    Return sb.ToString
End Function

:

sometext1, sometext2, sometext3, sometext4, , 
sometext5, sometext6, sometext7, sometext8, , 
sometext9, sometext10, , , , 

sometext1, sometext2
sometext5, sometext6
sometext9, sometext10

--------- ----------

List(Of List(Of String):

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
    Dim modvaluestmp(,) As String = {
        {"sometext1", "sometext2", "sometext3", "sometext4", Nothing, Nothing},
        {"sometext5", "sometext6", "sometext7", "sometext8", Nothing, Nothing},
        {"sometext9", "sometext10", Nothing, Nothing, Nothing, Nothing},
        {"sometext11", "sometext12", "sometext13", Nothing, Nothing, Nothing}
    }

    Dim stamps As New List(Of List(Of String))
    For y As Integer = 0 To modvaluestmp.GetUpperBound(0)
        Dim newRow As New List(Of String)
        For x As Integer = 0 To modvaluestmp.GetUpperBound(1)
            If Not IsNothing(modvaluestmp(y, x)) Then
                newRow.Add(modvaluestmp(y, x))
            End If
        Next
        stamps.Add(newRow)
    Next

    For Each row As List(Of String) In stamps
        Console.WriteLine(String.Join(", ", row))
    Next

    ' Example of accessing an element directly:
    Console.WriteLine("stamps(0)(2) = " & stamps(0)(2))
End Sub