JSL code to clear selected data table contents

terapin

I'm trying to do something that I think should be very easy to accomplish, but I can't find the JSL instruction that will let me.  Basically, after selecting various columns and rows I want to delete the contents of the selected cells, not the entire column or row.  I can do this manually, but can't find the JSL command to do so.  Any suggestions would be appreciated.

 

E.g.,

 

 

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Select Rows( [5, 7, 8, 10] );
Column ( "name" ) << Set Selected ( 1 );
Column ( "sex" ) << Set Selected ( 1 );

 

 

Now delete the contents of the selected cells.

 

Thanks.

ian_jmp

Something like this:

 

 

NamesDefaultToHere(1);
 
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
 
// Set up a selection of cells
dt << Select Rows( [5, 7, 8, 10] );
Column (dt, "name" ) << Set Selected ( 1 );
Column (dt, "sex" ) << Set Selected ( 1 );
 
// Function to set currently selected cells to '.' or ""
clearSelectedCells =
  Function({dt}, {Default Local},
  selCols = dt << getSelectedColumns;
  selRows = dt << getSelectedRows;
  for(c=1, c<=NItems(selCols), c++,
  dType = Column(dt, selCols[c]) << getDataType;
  if (dType == "Numeric",
  Column(dt, selCols[c])[selRows] = .
  ,
  Column(dt, selCols[c])[selRows] = ""
  );
  );
  );
 
// Use the function
clearSelectedCells(dt);