Welcome to the JMP User Community!

Latest Discussions

• How to open files with a certain file name only?

  Hi Guys,
  
  I am trying to open some files which have a certain name as follows:
  
  files1 = Files In Directory( "C:\log\*.test*" );
  
  However I do not get anything in files1. How can I just search for specific file names and save them in the files1 list?
  
  Thanks.

  

  Discussions |

  Mar 5, 2010 11:14 AM

  5005 views | 4 replies

• JSL Script to Initialize Data as Date Sequence

  I'm trying to write some JSL code that will:
  
  1) prompt user for starting and ending dates for range of data to initialized
  
  2) create new table and have this table add the number of rows equal to end date - start date, initialize new column with dates that increment by 1 day per row.
  
  Does anyone have any suggestions on how to accomplish this? I've included my test code so far. Thanks.
  
  Ron
  
  
  Dialog(
  VList...

  terapin

  Discussions |

  Mar 4, 2010 1:27 PM

  5633 views | 8 replies

• Distribution Bin

  First of all, I want to greet all the people in the community.
  This is first time for me to use this kind of Community Tools.
  
  In the Distributions:
  1) where can I see the value of the bin?
  2) which is the formula used from JMP to calculate the bin for the firts visualization?
  
  Thank you.
  Simone

  

  Discussions |

  Mar 2, 2010 6:43 AM

  3457 views | 1 replies

• convert day of week from date string

  Hello,
  
  Newbie question.
  
  I have the following date string 14-Jan-2010 and I would like to get the day of week
  from this string. Should I use the formula editor or write a script.
  
  I tried using the he formula editor "day of week" but I get an error.
  The error might have to do with the format of the date string.
  
  I think I need to parse the string and then determine what day of the week it is i.e. Sun...

  MaryLoveless

  Discussions |

  Mar 1, 2010 2:46 PM

  10096 views | 1 replies

• Accessing Oracle tables via ODBC

  Hi All,
  
  I'm new to JMP and need to go into an Oracle database and turn about 50 tables into JMP tables using JSL.
  
  I've found and can use the OPEN DATABASE command, but have several questions:
  
  1) Once you've opened the database, how do you disconnect from it at the end?
  
  2) The OPEN DATABASE Command accepts an SQL statement and a JMP table name. How do you get data from 50 tables and put them into 50 J...

  

  Discussions |

  Feb 28, 2010 5:50 AM

  4838 views | 5 replies