Hi Ravi,
The following is just a simple/crude script segment - modify/expand as needed - this looks at the 1st col of active worksheet, and then creates a new worksheet and copies over all masked rows of 1st col from source to new destiation sheet.
To execute, copy all lines and paste in script window, highlight all lines, and hit enter (click on source worksheet to make it the active window before doing this)
Easwar
OriginLab
// Get number of rows in current sheet
irows = wks.maxrows;
// Save name of current sheet in %a variable
%a=%h;
// Create a new sheet
win -t;
// Initialize counter
inum = 1;
// Loop over all rows of source sheet
for(ii=1; ii<=irows; ii++)
{
// If cell in 1st col is masked...
if( 1 == ismasked(ii, %(%a,1)) )
{
// Copy over to destiation
%(%h,1,inum) = %(%a,1,ii);
// Update counter
inum++;
}
}
Extracting Masked data
Posted - 10/21/2004 : 1:43:54 PM
