Welcome to the JMP User Community!

Latest Discussions

• Custom Date Format in JSL Script (For Query Builder)

  Overall Goal: Create a query in Query Builder that filters on a date time column only pulling data from the last 7 days of the current time. I am trying to use a custom expression in Query Builder to do this. Ideally it would just be the following in the custom expression filter but it results in no data pulled. t1.TimeCol >= format((Today() - InDays(7)), "m/d/y h:m:s") It appears Query Builder ta...

  bittnere

  Discussions |

  Jul 7, 2022 11:13 PM

  2799 views | 2 replies

• Wild card for Match function

  Hi Everyone,I had a variable "medium" and l needed a grouping variable so i created another variable for the grouping "EMEM Medium" and below if the code i used to populate the new variable.Match( :Medium, "Standard", "Standard", "Standard 1", "Standard", "Standard 2", "Standard", "Standard 3", "Standard", "Standard 4", "Standard", "Standard 5", "Standard", "Standard 6", "Standard", "Sigma...

  Mickyboy

  Discussions |

  Jul 7, 2022 4:28 PM

  2035 views | 3 replies

• Remove "" from the list

  Hi @txnelson ,I am trying to remove quotation mark "" from the list. The sitenum should have following results = {1, 2} no quotation mark. Any suggestions? new window("", modal, ht = checkbox({"1","2"}), Buttonbox("Ok", get = ht << get selected(); ) ); sitenum ={}; Insert Into( sitenum, get);  

  Jackie_

  Discussions |

  Jul 7, 2022 11:31 AM

  2145 views | 4 replies

• Presenting Data in JMP

  I have created a script which will generate several data tables and graphs. At the moment they open as several windows all over the place. I was wondering if I can stop them opening everywhere and instead open some kind of summary report which will show the tables and graphs I need, in the order I need, ideally allowing me to caption each table and graph.

  Jemster

  Discussions |

  Jul 7, 2022 7:39 AM

  990 views | 1 replies

• Splitting a string to extract numbers

  Hi , I have a string that is character and I want to extract a 4 number section. The position of the numbers may change An example of the string may bevalue ="Hello 0123 example"; I have tried this but only works if the numbers are in the correct position. value ="Hello 0123 example";extract=substr(value,7, 4); As the position of the number will change how can I extract this?  

  B1234

  Discussions |

  Jul 7, 2022 5:56 AM

  3024 views | 5 replies