Welcome to the JMP User Community!

Latest Discussions

• How to calculate linear-Log trapezoidal method (lin up /log down) in JMP?

  Hi!!I have previously been calculating the trapezoidal equation from my data without any issue in JMP but I need to run this time a Linear-Log trapezoidal method (lin up /log down).Can somebody give me a hand with the script or equation I should include for such type of analysis?  Thanks in advance.Best, Marlly

  Marlly_Guarin

  Discussions |

  Feb 1, 2021 2:56 AM

  2179 views | 2 replies

• script to add two column

  i am trying to add two columns.  two of the column has name abcd and efgh   following line works:   dt_tab << New Column( newcolumn, formula( :name( "abcd" ) + :name( "efgh" ) ) );   but following code is throwing an error     name1 = "abcd"; name2 ="efgh"; dt_tab << New Column( name1 || "3", formula(:name(name1) + :name(name2)));     why is the 2nd method not working? 

  tangxu

  Discussions |

  Jan 31, 2021 9:13 PM

  1837 views | 3 replies

• Compare strings and highlight differences

  How would I write a function or routine that would compare two strings and show the difference between them?e.g.string1="It will rain tomorrow"string2="It will snow tomorrow"comparison result (string2 vs string 1) = "It will rainsnow tomorrow"

  MathStatChem

  Discussions |

  Jan 31, 2021 6:18 PM

  5530 views | 6 replies

• Converting Military Time Format (hhmm) to Time Format (hh:mm)

  I need to convert military time in the hhmm format, e.g. 1432 or 725 to hh:mm format e.g. 14:32 to 7:25.  Is there a simple formula that can make the conversion, or should I use a script for it?  Thanks.

  nadershakerin0

  Discussions |

  Jan 29, 2021 9:00 AM

  28913 views | 11 replies

• Import Excel data from specific Excel cells

  I have situation where the data I need to analyze in JMP is stored somewhat haphazardly in in an Excel file.  I fortunately can easily get a list of the Excel cells that the data is in, and I would like to automate with JSL importing those values.  I am looking for ideas on how to do this effectively and efficiently.   For example, let's say the data I need in a single column in JMP  is stored in ...

  MathStatChem

  Discussions |

  Jan 29, 2021 8:08 AM

  4896 views | 7 replies