Welcome to the JMP User Community!

Latest Discussions

• Is there a way to uses Week of the year in Format Patterns?

  Dear Community,I want to make a string containing the week of a date,is it possible to do so with Format Patterns?Of course I could compose as a string, but I like the tight way doing it with Format Patterns. Thanks and best regards,  Names Default To Here( 1 ); Print( Format( Today(), "Format Pattern", "<YYYY>_<MM>" ) ); // Format Patern does not recognize WW Print( Format( Today(), "Format Patte...

  Georg

  Discussions |

  Aug 6, 2024 8:13 AM

  686 views | 3 replies

• Script executing differently on other computer?

  The following scenario: I have colleague overseas whom I wrote a script for. It is a script that loads data from a database, organizes the data in a table and puts a table script for control charting into the table. The table contains a few different products/processes and this one table script is targeted at only one of them (i.e., a tiny fraction of all rows). When I run the main and table scrip...

  Ressel

  Discussions |

  Aug 6, 2024 5:39 AM

  1188 views | 6 replies

• How can I create a multiple line graph with a categorical X-axis?

  Hey team, I'm Darshan Hiranandani,  I need to create a multiple line graph with a categorical X-axis for my project. Does anyone have any suggestions or best practices on how to achieve this? Your input would be greatly appreciated! Regards Darshan Hiranandani 

  darshanhira23

  Discussions |

  Aug 6, 2024 3:38 AM

  383 views | 1 replies

• How to make Regex case insensitive

  Hi.  Does anyone know the best way to make a regex search case insensitive in JSL?  For example, I wish to extract the file extension from a path name, and I don't want it to matter if the extension is ".csv" or ".CSV" or ".cSv".  If I try the following, it will only work on filenames whose extensions are lowercase: filename = Regex(path, "(.+\/)*([^\/]+)\.(csv|xlsx)$", "\2") One method is to just...

  nikles

  Discussions |

  Aug 5, 2024 2:01 PM

  13787 views | 4 replies

• Simple Looping Question

  I have what I think is a very simple looping question. I've looked in the scripting index and scripting guide and I just can't seem to figure it out. All I need to do is to create a table with a list of years beginning with defined earliest year and going to a defined latest year. So say 1960, 1961, 1962, etc. with one year in each row. The script I am using returns a blank column. Here it is... N...

  scott1588

  Discussions |

  Aug 5, 2024 1:00 PM

  798 views | 3 replies