Search rows in a webtable for text, then output the value

Hi,

I’m hoping someone can help me. I have a WebTable in a SAP application that I am trying to search through to find a specific text value, once found, to output the value of every cell on the row the text was found in.

For instance, I have a table with 4 columns and many rows, one or more of the columns contain the text I want, I need the script to loop through each row until it finds the text I am looking for, then output the text value in each cell on that row. The loop would end once it find a row with no data.


Any help would be much appreciated.

Thanks in advance,
Sean
Parents
  • Hross,

    Thanks! I did just what you said, it took a bit, but it did find the cells and the table. Seems it was a table within a table that through me off. I am able to identify the separate cells for output now using GetCellData. Now I am just trying to figure out the â Forâ statement to get the script to drop one row at a time until there is no more data found for out put. I decided it was best to grab all the data from all the rows, regardless of the text found. I can also sort it out later.

    Sorry, I am new to VBScript and trying to catch up. Can you provide an example for me based on that, or would what you already provided work?
Reply
  • Hross,

    Thanks! I did just what you said, it took a bit, but it did find the cells and the table. Seems it was a table within a table that through me off. I am able to identify the separate cells for output now using GetCellData. Now I am just trying to figure out the â Forâ statement to get the script to drop one row at a time until there is no more data found for out put. I decided it was best to grab all the data from all the rows, regardless of the text found. I can also sort it out later.

    Sorry, I am new to VBScript and trying to catch up. Can you provide an example for me based on that, or would what you already provided work?
Children
No Data