Welcome to the JMP User Community!

Latest Discussions

• Converting A Range of Alphanumeric Characters Into A List (X1-3 to X1,X2,X3)

  Hello,I'm trying to convert a range of alphanumeric characters into a list. I'm pretty new to JSL and I'm not sure exactly how to go about doing this. This is what I would like to achieve: Orginal: CH1-3Return: CH1,CH2,CH3 The character prefix does not always contain two characters (Could be CH1-3 or X5-8 for example). I know that if I had a range of just two numbers, like CH1-2,  I could use the ...

  Stepper

  Discussions |

  Jun 5, 2018 8:57 AM

  8348 views | 5 replies

• Creating a Variable

  I have an issue while creating an overall measure of time. I have attached a screenshot that shows what the data looks like thus far. I need to now create a variable that is called "time in trial" where I basically take the "Nback start" minus the "Nback stop." More specifically I would need several things to happen. 1. When "Nback # of letters presented" equals 1 the "time in trial" should equal ...

  tlsimons

  Discussions |

  Jun 5, 2018 7:59 AM

  2099 views | 1 replies

• Convert a list of strings into a column names

  I am trying a to run a script that uses a regex to find column names and puts them in a list to then stack. I am struggling to get the actual stack part to work and I think it has to do with the list containing strings rather then column names. Is there a way to convert a list strings into column names? ref = open(dir||datafile); allColNames = ref << getcolumnnames; edgeCols = {}; Ncols = N item...

  tarkan_bih

  Discussions |

  Jun 5, 2018 12:49 AM

  4885 views | 1 replies

• Retrieving a path and filename after Save Presentation() is used with no path specified

  I am using Save Presentation() to save a journal to ppt.  However, I want to allow the user to specify the path and file name to save the ppt.  If the Save Presentation() is specified without specifying a path/filename, JMP very nicely pops up an operating system Save File window, which allows the user to navigate to whatever folder they desire, and to specify whatever filename they desire.  The i...

  txnelson

  Discussions |

  Jun 4, 2018 12:28 PM

  6374 views | 6 replies

• SQLQuery

  Hi, I've made a sqlquery.jmp from an excel file (xlsm).When I execute for the first time: no pb. the jmp file is created.but when I try to update the jmp file by "update from Database" (I use JMP14), the file is not updated.The excel file is write protected. In excel, the file requests a password for writing / reading. I can only open it as read-only.is it the explanation?What should I check ? tha...

  Françoise

  Discussions |

  Jun 4, 2018 10:18 AM

  6032 views | 2 replies