cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
Damian
Level I

Parsing datetime information + conversion with milliseconds

I am new to JMP and I am trying to batch process many .csv files. My first hiccup is happening when I try to pull datetime information from the first column.My data table looks like 

Damian_0-1605745343072.png

 As you can see from the picture, each row of timestamps has an unwanted "-0800" tacked on the end How would I get rid of this for each entry? The jsl syntax I used looks something like

 

:loggingTime = Substr( :loggingTime , 1 ,  23)

 

However when I run this, I just end up with an empty column. Lastly, I know to ultimately format the string into a datetime object I will need the "informat" command  but my question there is can I select a format that records milliseconds and that doesnt just stop at seconds? I know this is simple stuff but as I said I am new to JSL and any help would be greatly appreciated.

 

1 REPLY 1
txnelson
Super User

Re: Parsing datetime information + conversion with milliseconds

if you run this script, it should fix your LogingTime data

Names default to here(1);
For Each Row(
     :loggingTime = Substr( :loggingTime, 1, 23 );
);

Formats will automatically loop through each row, but scripts require one to do the looping within the script.

Concerning your informat issue....Here is a format that if you create a new column, and specify the below as the format, it will convert your LoggingTime to a JMP date time value.  All you need to do then, is to specify the DateTime format you want to use for the displaying of the value

num(format(informat(date,"yyyy-mm-dd h:m:s"),"fixed dec",23,3))
Jim

Recommended Articles