Hello everyone,
I have a tablle inside a terminal, with the columns as follows:
First Name Last Name Balance Status Paid
Considering that I need to check if one or more rows have the status column populated, what is the fastest possible method? Considering I can do get text and have a text string that contains all the information?
Hello @Kumar802,
You can try to loop through your data from that column and compare each element with that empty string value.
From other perspective, the values inserted in that column have different length from one to another?
yes, it seems like:
First Name Last Name Balance Status Paid
A B 10000 1300 Y
B C 8000 F
here I should locate the second row, with empty status, and the values can have variable values
Try to loop through the entire table and for each row compare the specified column “Status” with empty string value 
unfortunately i can extract through get text, so it’s a plain text without any delimitators or column
Oki, got it.
So each time this column is indexed by 6, am I right?
If all other columns will have data always then you can ideally split on space and get the count…if count is 4 then status is missing
First do a split on newline to get each row separately then split on space
Strsingleline.Split({" "},Stringsplitoptions.RemoveEmptyEntries).Count>4
Use str.Split({Environment.Newline,vbcrlf},SplitStringoptions.RemoveEmptyEntries) - this will give you each row item as a liat item…loop through each row and check the above condition on count