905465_en-US

liliconcom

Select a block of cells based upon a condition

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.

 

 to 

 

 

 

Automation and ScriptingRe: Select a block of cells based upon a condition

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=""></SELECT>

Re: Select a block of cells based upon a condition

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

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);