Welcome to the JMP User Community!

Latest Discussions

• Validate column name exists before graphing

  Hi,  I am trying to validate that a data table contains a certain column name prior to creating graphs:hasname1 = 0;
       for (colval == 1, colval <= Ncols(dt), colval++,
             colName = Column Name(colval);
             if ( colName == "name1",
                   hasname1 = 1;           );
  if (hasname1 == 1,
        //create graph
  );However, the comparison never returns true because "name1" is a string ...

  senatorx

  Discussions |

  Jun 16, 2012 9:26 PM

  8781 views | 2 replies

• Populate new column based on values of another column

  I'd like to do something like an Excel VLOOKUP  ----   where I'd like to populate an empty new column (New_Status) with values from the original column (STATUS) ---  but some of the values need to be translated....   many of the original status entries do not state explicitly that the item is 'Open' but for my purposes they are open.... so I'd like a column that consolidates all the text that mean...

  twaintwist

  Discussions |

  Jun 15, 2012 1:12 PM

  13294 views | 3 replies

• Integer to String data type conversion in JSL

  Hi, This is my first post in the forums.I am attempting to concatenate a number to a string for the purpose of saving a timestamp to an image name like so:ChartName <<  save picture ("file_name" || "date" || ".png", png);However, JSL will not allow the date information to be concatenated because it is an integer and not a string.I gather datetime information  usingyyyy = year(today());hh = hour(to...

  senatorx

  Discussions |

  Jun 13, 2012 5:42 AM

  12266 views | 2 replies

• Can you remove all menu items from New Window() ?

  Hello,I'd like to remove all the default menu items from the Window I create when using the New Window() function.I didn't find any documentation on this in the "JMP 10  Scripting Guide" that I'm using to learn JSL.The default menu items have no meaning within my application, and I like to be able to present the users with an uncluttered dialog box.Thanks for your help.Robert 
  

  restonian

  Discussions |

  Jun 11, 2012 6:41 AM

  8817 views | 2 replies

• select text between delimiters

  Hello,  I'm trying to write a formula to select text that lies between the delimiters [ ].All text in my column appears as below:RinseAid[Apex.Rinse]*(Temp-130)RinseAid[AutoDri]*(Temp-130)RinseAid[Bright&Dry]*(Temp-130)RinseAid[Clarity]*(Temp-130)...I want to keep only the text between the [ ] symbols:Apex.RinseAutoDriBright&DryClarityBut using a formula such as below, Iget a mesage that the formu...

  paulp

  Discussions |

  Jun 10, 2012 1:33 PM

  3560 views | 1 replies