While doing web extraction, the script checks for a condition of emptyness in order to loop again. This empty variable causes an empty row between loops. So the grid looks like.

data
data

data
data

data
data

How do i remove the empty rows in the grid? I tried doing a "loop grid" and "get data cell" with an exit "If condition is empty" but obviously it exits when it reaches the first empty cell (which I want to delete the row) i cant figure what the best way to delete empty rows and exit this loop

thanks

Try this:

1 Show Grid Viewer: Action: Show for [All]
2 Set Data Cell Value with value Data in row 1 of column 1 using data grid [DataGrid1]
3 Set Data Cell Value with value <empty> in row 2 of column 1 using data grid [DataGrid1]
4 Set Data Cell Value with value Data in row 3 of column 1 using data grid [DataGrid1]
5 Set Data Cell Value with value <empty> in row 4 of column 1 using data grid [DataGrid1]
6 Set Data Cell Value with value Data in row 5 of column 1 using data grid [DataGrid1]
7
8 Loop Data Grid Rows in source [DataGrid1], store current row in [Number1]
9 Get Data Cell Value from row [Number1] in column 1 using data grid [DataGrid1] and store in variable [cellvalue]
10 If [cellvalue] Equal To <empty> then
11 Delete Data Grid Row(s) [Number1] in source [DataGrid1]
12 End If
13 End Loop