Forum Discussion

rramkis's avatar
rramkis
New Contributor
10 years ago

need to retrieve a row number where expected values find

I have a one table. in the table I want to retrieve a some expected values let assume that A,B,C these three I want to find . once its found I want to retrieve row number of each one.. the row number...
NisHera's avatar
NisHera
Valued Contributor
10 years ago

This is kinda psudo code for your problem 

Looks more like jscript

have to rewite in vbs and get values using correct grid methods

For (i =0 to RowCount){
    var AExist = false
    var BExist = false
    var CExist = false
    For (j = 0 to columncount){
	     P = grid.wvalue(i,j)
	     if (p == A)
		   {AExist = true}
	     if (P == B)
		   {BExist = true}
             if (P == C)			
		   {CExist = true }}
    If (AExist and BExist and CExist)	 
	  {Log. message ("A B C Exists in the row number "+ i) }}