Welcome to the JMP User Community!

Latest Discussions

• Keeping comma containing values from being split into columns during CSV import

  Short version: the CSV files I am working which occassionally contain text strings which include a comma.The JSL I have written to open this table very neatly splits the string at the comma and send the part after the comma into the next data column - exactly where it doesn't go. Excel will get it right when opening this file. Is there a way to get JMP / JSL to treat this one comma as just a chara...

  ckerr

  Discussions |

  Jan 31, 2018 10:53 AM

  12162 views | 5 replies

• Open files (lookup characters from file name)

  All,
  I am trying to open files in a folder by searching characters of file name based on user input./* Input values in 3 columns by user. eg of file name: ABC_12_XYZ. User will input ABC in 1st column, 12 in second col and XYZ in 3rd column. all three should match in a row for selecting the file. There could be 100's of files (unique name) in the folder. User will input all that he wants to select ...

  CG

  Discussions |

  Jan 30, 2018 3:43 PM

  9487 views | 6 replies

• Select where using several conditions

  Hello, I am struggeling with selecting several rows according to some specific values. I want to select rows where a column cell contains specific values. I manage to select according to two columns with specific values but I cannot add values from the same column that should also be taken into consideration for row selection. My code that works looks like this:dt=Current Data Table ();
  dt<< select...

  Pacco

  Discussions |

  Jan 30, 2018 1:25 PM

  15268 views | 7 replies

• JSL scripts run automatically in JMP 13 when double clicked to open. How to stop it?

  I recently upgraded from JMP 11 to JMP 13.1. All my scripts were created in JMP 11. I am now seeing that my scripts are automatically executing everytime I try to open them by double clicking on the script. The settings in the "Preferences" section is unchecked for "JSL scripts should be run only....". See snapshot of the settings below. I am out of options to fix this. The only other way where I ...

  bharathu

  Discussions |

  Jan 30, 2018 10:48 AM

  9656 views | 4 replies

• Is it possible to have 3 blocking variables in Custom design in JMP?

  Hi, I was using JMP's custom design option to develop a design for a screening experiment. I am using custom design since I have mixture variables. I know it is possible to have 2 blocking variables in the design using the method mentioned here: https://community.jmp.com/t5/JMP-Blog/Constructing-a-custom-design-with-2-nested-random-blocking/ba-p/30170  But is it possible to have 3 blocking variabl...

  akrishna39

  Discussions |

  Jan 30, 2018 8:00 AM

  6265 views | 2 replies