topic Re: Select a block of cells based upon a condition in Discussions

Select a block of cells based upon a condition

SpannerHead — Wed, 01 Oct 2025 22:17:01 GMT

I would like to select a data table cell containing a specific string and any populated rows in the same column below the string until I reach an empty cell? If Value were the text, I'd like to grab the ones below that. Can't immediately think how to do that.

Re: Select a block of cells based upon a condition

txnelson — Wed, 01 Oct 2025 23:58:57 GMT

Try this

names default to here(1);
dt=current data table();

flag=0;
for each row(
	If(:theColumn == "Value", flag=1,
		:theColumn == "", flag=0
	);
	If(flag==1, dt<<select rows(Row()))
)

Re: Select a block of cells based upon a condition

SpannerHead — Thu, 02 Oct 2025 13:00:17 GMT

txnelson

That's brilliant, and really close! It selects the entire rows but I'd like to constrain it to cells in

:theColumn

Re: Select a block of cells based upon a condition

SpannerHead — Thu, 02 Oct 2025 13:17:57 GMT

txnelson

Small tweak got me there. Thanks.

names default to here(1);
dt = current data table();

flag=0;
for each row(
	If(:theColumn == "Value", flag=1,
		:theColumn == "", flag=0
	);
	If( flag==1, dt << select rows(Row()))
);

dt << Select Columns(:theColumn);