Delet masked points

http://www.originlab.com/forum/topic.asp?TOPIC_ID=7831&SearchTerms=IsMask http://www.originlab.com/forum/topic.asp?TOPIC_ID=3453 1. !comments: [->< Select Worksheet : Extract Worksheet Data... To Delete: Select the column with Masked values (presumably your Y column) Click the => button to create an Alias (in this example : B) In the Condition text box, type B[i]!=0 Click Test -- select if true button (This causes only those rows with masked values to be selected.) Click the Close button Select Edit : Delete from the menu (NOT the Delete key) All rows with masked values are removed. To Copy: Select the column with Masked values (presumably your Y column) Click the => button to create an Alias (in this example : B) In the Condition text box, type B[i]==0 Select 'Extract to New Workbook' as Output Click OK New Workbook will contain only those rows without masked values. 2. // 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; %z = %h; // 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)) ) { for (jj=1; jj<=wks.nCols; jj++) { // Copy over to destiation %(%h,jj,inum) = %(%a,jj,ii); } // Update counter inum++; } } wks.export.cntrl = 2; save -wh %h %1; win -c %h;