StringRegExp or something else?

[xcaliber13]

I have this to delete a row in excel

For $i = $iLastRow To 1 Step -1
      If _Excel_RangeRead($oWorkbook, Default, "C" & $i) = "Q9967" Then
           $oExcel.Rows($i).Delete
       EndIf
Next

Works great but how do I delete a row  in c column if  the data in the cells starts with Q99.    So not only will it delete Q9967, but also Q9968, Q9969, etc.  I started to write For/Next loops for each different data set but there must be a better way.  I was thinking StringRegExp but really not sure how to get that to work or even if that is the way to get there.   Thank you

[iamtheky]

maybe something similar to:

For $i = $iLastRow To 1 Step -1
        $sXLread = _Excel_RangeRead($oWorkbook, Default, "C" & $i)
        If stringleft($sXLread , 3) = "Q99" Then
           $oExcel.Rows($i).Delete
       EndIf
Next

 

Edited July 20, 2016 by iamtheky

[xcaliber13]

OK! That worked perfectly.  So read to a variable and use stringleft.  Very nice iamtheky   Thank  you

[iamtheky]

reading to the variable probably isnt necessary, just better for debugging

If stringleft(_Excel_RangeRead($oWorkbook, Default, "C" & $i) , 3) = "Q99" Then

should work fine, but combining a bunch of functions together isnt recommended lest the return is reliable.  If later you want to add an if error check on the rangeread, or make sure that string isnt blank, or reuse that string to save you a costly second read; you need it separately.