I have a script that had been working in JMP 10 but now is not with JMP 11.  Someone else created this script so I'm learning my way through it.  The portion of the script that is causing problems is pasted below.  More specifically, I believe it is in the portion highlighted blue.  Any ideas??  ChronJoin=Function({}, //02        //Joins data in the chronological order        for( f = 2, f <= N Items(ShortList), f++,            try(                dt = open(directory || ShortList ),            /*catch*/                print("Error 002a: Unrecognized file type "|| ShortList );                throw();           );           if(!contains(column name(1), "Date"),  //if the column name of column one is not Date                RowRemove("Date", 1, "Time", 2);  //removes headers                ColumnRename(ShortList );  //renames the columns           );           FixRawSecondsName();           ColumnFormat();  //sets the correct data types for the columns           if(N Items(MultiVarCheckBox << Get Selected())!=0,                MultiVarColumn(ShortList );           );           if(N Items(HALTlinesCheckBox << Get Selected())!=0, //Verticle Reference Lines selected                if(TestTypeRadioBox << Get()==1,  //HALT                     HALTstages(ShortList ),                /*else if*/TestTypeRadioBox << Get()==4,                     SAstages(ShortList );                );           );           try(  //if dt cannot be joined, an error is printed to the log and the script is stopped                dtPrev = dtMain;                dtMain = dtMain << Join(                     With(dt),                     Merge Same Name Columns,                     Copy Formula(0),                     Suppress Formula Evaluation(0),                     By Matching Columns(:Date == :Date, :Time == Time),  //joins by matching Dates and Times                     Drop Multiples (1, 1),                     Name("Include non-matches")(1, 1),                     Output Table Name("Digital" || char(f), nosave);                ),           /*catch*/                print("Error 002b: Failure to join "||ShortList );                throw(); //ends current script sequence           );                close(dt, nosave );  //closes the recently opened data table                close(dtPrev, nosave);  //closes the previous data table      );      while(contains(column name(1), "Match Flag"),           dtMain << Delete Columns("Match Flag");      ); ); ... View more

I have a set of file names that contain within the name an ID number. These ID numbers do not necessarily have the same character length. Any ideas on how to achieve this? This is what I have for fixed ID character length. For (k =1, k < N Items( listOfFiles ), k++, IDNumber = subsr( listOfFiles , 1, 8 ); insertinto( listOfIDNumbers, IDNumber ); ); Issue arises when ID number is not 7 characters in length and I have complex filenames. ABCDE_1234567_ABCD.csv ABC_123_ABCDEFG.csv What I want is to just get 1234567 and 123. Can I key off .csv somehow or perhaps underscore? ... View more

I have a table that is test data from multiple test subjects. Due to system issues, occasional rows are "bad", affecting all test subjects. The columns hold data for each test subject. I would like to delete these bad rows based on criteria from all columns. Criteria is that if every column has a value below x, that row is deleted. Seems that I need to use "For Each Row" in combination with If() and And() but scripting guide does not have any helpful examples using And(). Any tips? I could do this manually except I have over a million rows. ... View more