HIya,
How do I tackle such problem. I have a column of data like os:
[TABLE="width: 500"]
<tbody>[TR]
[TD]ZZprod1[/TD]
[/TR]
[TR]
[TD]Tbales[/TD]
[/TR]
[TR]
[TD]long tables[/TD]
[/TR]
[TR]
[TD]2[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]3[/TD]
[/TR]
[TR]
[TD]Sbales[/TD]
[/TR]
[TR]
[TD]Short tables[/TD]
[/TR]
[TR]
[TD]43[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]ZZProduct2[/TD]
[/TR]
</tbody>[/TABLE]
So I basically want to check if between after a cell containing a value including"ZZ" , or rather if values between cell containing a value which contains"ZZ" to the row with the cell containing next "ZZ" value, ranges that start a row below (Tbales,long tables2,2,*,3) contain exactly 4 rows . So, in this case, the code would delete a row with "*", but also exclude specific words like "KILO". a range (of rows) would always start with a text(Tbales) and end a row up of the next text (Sbales).
How do I tackle such problem. I have a column of data like os:
[TABLE="width: 500"]
<tbody>[TR]
[TD]ZZprod1[/TD]
[/TR]
[TR]
[TD]Tbales[/TD]
[/TR]
[TR]
[TD]long tables[/TD]
[/TR]
[TR]
[TD]2[/TD]
[/TR]
[TR]
[TD]*[/TD]
[/TR]
[TR]
[TD]3[/TD]
[/TR]
[TR]
[TD]Sbales[/TD]
[/TR]
[TR]
[TD]Short tables[/TD]
[/TR]
[TR]
[TD]43[/TD]
[/TR]
[TR]
[TD]32[/TD]
[/TR]
[TR]
[TD]ZZProduct2[/TD]
[/TR]
</tbody>[/TABLE]
So I basically want to check if between after a cell containing a value including"ZZ" , or rather if values between cell containing a value which contains"ZZ" to the row with the cell containing next "ZZ" value, ranges that start a row below (Tbales,long tables2,2,*,3) contain exactly 4 rows . So, in this case, the code would delete a row with "*", but also exclude specific words like "KILO". a range (of rows) would always start with a text(Tbales) and end a row up of the next text (Sbales).