topic Change format to duration with script in Discussions

Change format to duration with script

nm1 — Sat, 10 Jun 2023 23:14:59 GMT

I am importing data from an excel spreadsheet. I have one column that exists in this excel as a duration (format=min:s). This is imported automatically as character. I would like to change it to a duration within a script. As suggested in lots of posts (eg here:

I tried the following:

column(dt,"Cycle Time")<<data type(Numeric)<<Modeling Type(Continuous)<<Format( "min:s",12,0);

but this gives me a column of only missing values. (dt is my imported data table, "Cycle Time" is the name of the column). The conversion works when I do it manually, using the Column Info dialog.

I am using Jmp15.1.0 on Windows. Any help would be greatly appreciated.

Re: Change format to duration with script

Mark_Bailey — Mon, 22 Jun 2020 16:09:40 GMT

There is an optional form of the << Data Type message that combines all three steps:

So your code might change to:

Column( dt, "Cycle Time" ) << Data Type( "Numeric", Format( "min:s" ) ) << Modeling Type( "Continuous" );

See if that form works better.

Re: Change format to duration with script

nm1 — Mon, 22 Jun 2020 17:38:21 GMT

Yep, that did the trick - thanks for the quick response!