I need to open a log file from a tool that is in simple Tab separated format. This in itself isn't an issue - JMP is the only program I can find that will open the file as it contains the Temperature and Humidity measured every minute since Feb 2012 - it is 184Mb in size!
My issue is the date format in the file - an example is:
17:43:14 - 20120222
hh:mm:ss - yyyymmdd
I am trying to use this for filtering but, of course, JMP sees it as a Character data type.
Using Left and Right in Formulas I have been able to get to a point where I have the Time and Date separately as Character fields. My Date formula looks like this:
Right( Right( :Time Date, 8 ), 2 ) || "/" || Left( Right( Right( :Time Date, 8 ), 4 ), 2 ) || "/" || Left( Right( :Time Date, 8 ), 4 )
![RichardSlack_0-1620127219569.png RichardSlack_0-1620127219569.png](https://community.jmp.com/t5/image/serverpage/image-id/32578iC4E351271C8A115E/image-size/medium?v=v2&px=400)
But I am lacking the knowledge to go the last step to get a date and Time in a Continuous Numeric format - e.g. ddMMMyyyy hh:mm:ss
Can anyone suggest the best way to do this please? I am happy to look at Scripting options or Formula based options.