Finding a string in an array

[Docfxit]

I have a field $asFields[5] in a record that looks like this: "BAJA FRESH MEXI GRILL VALENCIA CA "

I need to search an array that I loaded called $Vendor that looks like this:

[1]|Vendors

[2]|CHEVRON

[3]|BAJA FRESH

[4]|GRAND PANDA

[5]|LENOVO

When it finds Baja Fresh I need to know the index so I can use an alternating array.

Func ReadRecord()   ;  Read the transaction records
    While $fResult = 1
        Global $sString = FileReadLine($hQBTrans)
            If @error = -1 Then 
                ;End of file reached
                ExitLoop
            EndIf
        $asFields = StringRegExp($sString, $sPattern, 3)
        _ArrayDisplay($asFields, "Input Fields")                                                        
            If $asFields[0] = "TRNS" Then 
                $Pos = _ArraySearch ($Vendor, $asFields[5], 0, 0, 0, True)
                Select
                    Case $Pos = -1
                        MsgBox(0, "Not Found", '"' & $asFields[5] & '" was not found in the array.')
                    Case Else
                        MsgBox(0, "Found", '"' & $asFields[5] & '" was found in the array at pos ' & $Pos & ".")
                    EndSelect
            EndIf
            MsgBox(4096, "Record", "InputString - " & $sString & @LF & "Result - " &$fResult)
    WEnd            
EndFunc

How can I find the vendor strings?

Thank you,

Docfxit

Edited - Added _ArraySearch

Edited September 28, 2007 by docfxit

[Xenobiologist]

Hi,

_ArraySearch ?

So long,

Mega

[Docfxit]

Hi,

_ArraySearch ?

So long,

Mega

Thank you for pointing me in the right direction. I added _ArraySearch to my sample above. The problem with what I have is I need it to come up with a match on part of the string. Right now it's looking for the entire string in the $Vendors array. In this example I need to have a hit on BAJA FRESH.

Thank you,

Docfxit

[Xenobiologist]

Hi,

there is a parameter called $fPartialSearch. Does this not help?

So long,

Mega

[Docfxit]

Hi,

there is a parameter called $fPartialSearch. Does this not help?

So long,

Mega

I tried it with $fPartialSearch = true and it didn't find a match. I'm not sure how it could though.

The string I am searching with (What to search) is "BAJA FRESH MEXI GRILL VALENCIA CA " Note: There will be a file of about 200 records.

The array I am searching in is:

[1]|Vendors

[2]|CHEVRON

[3]|BAJA FRESH

[4]|GRAND PANDA

[5]|LENOVO

Note: The vendor array will be about 100 to start and it will grow.

The only way I could see this working is if I sequenced through the entire vendor array for each and every record. That way the Vendor would be What to search for and the field $asFields[5] would be What to search in. I'm guessing that would be some kind of string search instead of an arraysearch.

Thank you,

Docfxit

[Blue_Drache]

For $x = 0 to Ubound($array) - 1
   If StringInStr($array[$x],$search) > 0 then
      MsgBox(0,"","FOUND IT!!!")
   EndIf
Next

Edited September 28, 2007 by Blue_Drache

[Docfxit]

For $x = 0 to Ubound($array) - 1
   If StringInStr($array[$x],$search) > 0 then
      MsgBox(0,"","FOUND IT!!!")
   EndIf
Next

That worked excellent.

Thank you very much,

Docfxit

[GEOSoft]

I also posted a function to find all occurences of a search string in an array so Baja will return all elements containing the string Baja

http://www.autoitscript.com/forum/index.php?showtopic=51629