710844_en-US

liliconcom

text DATE-TIME convertion to date-time format

Using JMP 10.0.0

 

I have a txt string that looks like this in a TXT field.    need it as  mm/dd/yyyy hr mm as a date-time number.

03/06/2015 1659 

I am several frustrating hours into what is likely simple .. and can't do it in JMP or Excel ... so, will parse and reassemble the txt and move forward, but really, this should not be this hard.  

 

Would appreciate your help.  Tried "custom formats" in JMP and got nothing ..  

 

Thanks in advance.

 

Tom

Basic Data Analysis and ModelingmacOSRe: text DATE-TIME convertion to date-time format

Correction ... am using JMP 17.0.0 ..  dont know why that changed.

 

tom

Re: text DATE-TIME convertion to date-time format

Here is my way of handling this

Names Default To Here( 1 );

text = "03/06/2015 1659";
// JMP will not recognize the hour and minutes without
// a colon(:) between them, so simply add it in
text = left(text,13) || ":" || right(text,2);

// Now the informat() function can read in the 
// text field and convert it into a JMP Date/Time
informat(text, "m/d/y h:m");