Welcome to the JMP User Community!

Latest Discussions

• Parse Outermost Quoted String

  I am writing a script that makes an additional script on the data table as "New Script". But I am having a problem with parsing the string I have set up as the code to be placed in the new script. The problem is when I run "dt << New Script("Script", parse(a));" when it parses the string, it assumes the quote prior to the Graph Builder is the first quote and then ends that quote at the beginning o...

  Martin

  Discussions |

  Nov 15, 2022 9:38 AM

  2103 views | 4 replies

• Prepping list column names for future use

  Hello, I'm trying to retrieve and prep a list of column names to save in a variable to use later. The issue is that << Get Column Names() returns everything as a list of strings. Below is how I've added in a " : " to the beginning of each item string and what a potential usage of this may be. More still needs to be done. names default to here(1); dt = current data table(); col_names = dt << Get C...

  StarfruitBob

  Discussions |

  Nov 15, 2022 9:05 AM

  1632 views | 3 replies

• JMP doesn't recognize year from date column when importing Excel to JMP table

  I have an Excel worksheet with date column where the date is shown as D-MMM.When I imported this worksheet to JMP using Excel Import Wizard, JMP recognize only D-MMM After I have edited the column format from <D><-><MMM> to be <D><-><MMM><YYYY>, JMP thought that the <YYYY> is 1904 (default year) What should be the better way to fix this? I can only think of two ways currently, not sure if there ar...

  Nita_Natchanok

  Discussions |

  Nov 15, 2022 7:14 AM

  5197 views | 7 replies

• How do I turn off "open with default program" when opening csv files?

  Hello everyone, Every time I try to open a new csv file in JMP, this is the default.Does anyone know how to make this unchecked by default?  I have never wanted to use JMP to open a file in Excel. Many thanks, John

  JohnDMoore1

  Discussions |

  Nov 15, 2022 5:32 AM

  1948 views | 2 replies

• Case Insensitive searches using contains

  I am using the following piece of code to check if the list cn contains "col_name" and if yes rename it as Target.The problem is col_name can be all upper case or lowercase and there is no way for me to control that.How do I make sure that the code gets executed irrespective of the case?   If( Contains( cn ,Lowercase("col_name") ), :"col_name" << Set name("Target"); );   Thanks

  ENTHU

  Discussions |

  Nov 15, 2022 12:43 AM

  4348 views | 4 replies