Select Where crashing JMP

Hegedus

Building a simple script to import and clean up data.  The open works as expected gives me the data table.  When I add the second command where I am looking for the rows that have the term "Finder" in it to prepare to delete those rows.  When I uncomment that line and run it. JMP crashes. Where am I going wrong?

dt=Open(

  (pick file()),

  columns(

  Column 1 = Character,

  Column 2 = Character,

  Column 3 = Character,

  Nominal = Numeric,

  Upper Tol. = Numeric,

  Lower Tol. = Numeric,

  Name( "1" ) = Numeric

  ),

  Import Settings(

  End Of Line( CRLF, CR, LF ),

  End Of Field( Comma ),

  Strip Quotes( 1 ),

  Use Apostrophe as Quotation Mark( 0 ),

  Scan Whole File( 1 ),

  Labels( 1 ),

  Column Names Start( 21 ),

  Data Starts( 111 ),

  Lines To Read( All ),

  Year Rule( "10-90" )

  )

);

dt<<Select Where(contains(column(1),"Finder")>0);

//dt<<Delete rows;

I am using JMP 8.0.1 on MacOS X.

pmroz

Try using get rows where instead of select where.  This code works in JMP 11; not sure about 8:

found_rows = dt << get rows where(contains(as column(1),"Finder")>0);

if (nrows(found_rows) > 0,

     dt << delete rows(found_rows);

);