Choose Language Hide Translation Bar
Highlighted
lwx228
Level VII

How do I import this Hour and minute data into JMP?

Hello, everyone!

 

Use "Data with Preview" to import Hour and minute data from the TXT file into JMP, but don't know how to tune the Data.Thanks!

 

2018-11-03_21-54-20.png

 

 

5 REPLIES 5
Highlighted
lwx228
Level VII

Re: How do I import this Hour and minute data into JMP?

txt
Highlighted
txnelson
Super User

Re: How do I import this Hour and minute data into JMP?

The issue you are having is that you are specifying a format of "h:m:s", and your data is "hhmmss".  And, there isn't an "hhmmss" format in JMP.  So what you need to do, is to read in the data specifying the Hour column to be read in as a character column, and then run this simple script:

names default to here(1);
dt=current data table();
for each row(
	:Hour = left(:Hour,2) || ":" || substr(:hour,3,2) || ":" || right(:Hour, 2)
);

dt:Hour << data type(numeric)<<informat("h:m:s")<<modeling type(continuous)<<format("h:m:s");
Jim
Highlighted
lwx228
Level VII

Re: How do I import this Hour and minute data into JMP?

Thank Jim!
Highlighted
lwx228
Level VII

Re: How do I import this Hour and minute data into JMP?

It is recommended that JMP add this option.
Highlighted
txnelson
Super User

Re: How do I import this Hour and minute data into JMP?

If you want to make this suggestion, please add an entry in the JMP Wish List
Jim
Article Labels

    There are no labels assigned to this post.