Indexof Problem

[grimtar]

So I have the first form working, more or less an exact copy of what i'm about to post, but the problem I'm running into is that indexof(textbox1.text + " total") is indeed searching for the right thing, but it's not SEEING it, is there any reason for this? Here's the code.

      'WAREHOUSE
        Dim SKUSheet2 As New ArrayList
        Dim ReturnValueWH As Integer

        Using MyReader As New  _
        Microsoft.VisualBasic.FileIO.TextFieldParser(ofdWarehouse.FileName)
            MyReader.TextFieldType = FileIO.FieldType.Delimited
            MyReader.SetDelimiters(vbTab)
            Dim currentRow1 As String()
            While Not MyReader.EndOfData
                Try
                    currentRow1 = MyReader.ReadFields()
                    Dim currentField As String
                    For Each currentField In currentRow1
                        SKUSheet2.Add(currentField)
                    Next
                Catch ex As Microsoft.VisualBasic.FileIO.MalformedLineException
                    MsgBox("Line " & ex.Message & _
                    "is not valid and will be skipped.")
                End Try
            End While
        End Using
        Dim Pachow As String = ""
        Pachow = textSKU.ToString & " Total"
        ReturnValueWH = SKUSheet2.IndexOf(Pachow.ToString)
        If ReturnValueWH = -1 Then

            textWarehouse.Text = "NOT FOUND"
        Else


            ReturnValueWH = ReturnValueWH + 1
            textWarehouse.Text = SKUSheet2(ReturnValueWH)

Don't mind the pachow variable, I was tired and running out of variable names in my head. Now the format of the file is more or less like this.

SKU QUANTITY LOCATION
AD-DL-003 780 Q34-A
AD-DL-003 Total 780
AD-HP-026 10 Q12-A

A tab separates the columns in the file, it just doens't look like it here. It parses it correctly as far as I can tell, it outputs into a messagebox when i change it to do that. Why would it not be seeing the total part? Any ideas?

[EntityX]

Right here in the code :

 Pachow = textSKU.ToString & " Total"
 ReturnValueWH = SKUSheet2.IndexOf(Pachow.ToString)
 If ReturnValueWH = -1 Then

try

 Pachow = textSKU.ToString & " Total"
 Label1.Text =  "Pachow = " & Pachow & "   SKUSheet2 = " & SKUSheet2' Get a look at exactly what Pachow is right here as well as SKUSheet2.
 ReturnValueWH = SKUSheet2.IndexOf(Pachow.ToString)
 If ReturnValueWH = -1 Then

[grimtar]

I must be an idiot, when I throw in what you said it says label1 not defined(I've never used anything called a label, but sounds familiar? like I said, I'm sure it's obvious I'm just dumb ), and the & operator does not belong to the arraylist class, but if what you're trying to do is see if it's showing " XXX-XX-XXX Total" I have looked at that through the debugger watch button and it shows "XXX-XX-XXX Total" like it should be, but for some reason it doesn't see it.

[grimtar]

Anyone? Could really use the help! I only want hints preferably, been searing all over the documentation all day, and I can't figure it out.

[stanav]

The thing is when you add the values to your arraylist, you only add the SKU number

SKUSheet2.Add(currentField)

However, the value you assigns to Pachow is some SKU number + " Total"

Pachow = textSKU.ToString & " Total"

And that's why when you do an indexof, it never finds the item in the array list because none of the items in the array list has the " Total" suffix.

[grimtar]

I suppose the format of the source file is a bit misleading in the above post, there is a tab between the everything, except the SKU and the word total, that's a space, and the delimiter is set to a tab. I'm not sure why that doesn't translate into the post above, but that's how it looks. Or did I miss the point of your post entirely?