Hi Community,
I have data table with column TimeStamp 2023_10_04 02:22:24. Right now i already split the date & time into separate column using this script below:
Names Default To Here( 1 );
dt = Current Data Table();
dt << Text To Columns( delimiter( " " ), columns( :TimeStamp ) ); // in delimiter is SPACE
// Close the original timestamp column
dt << Delete Columns( "TimeStamp" );
dt << Delete Columns( "TimeStamp 1" );
But the format column still in 24 hour
![mystylelife19_0-1696414048500.png mystylelife19_0-1696414048500.png](https://community.jmp.com/t5/image/serverpage/image-id/57202i078AE4D38B92C31C/image-size/medium?v=v2&px=400)
I want format 12 hour like this
![mystylelife19_1-1696414134828.png mystylelife19_1-1696414134828.png](https://community.jmp.com/t5/image/serverpage/image-id/57203i09A6747B45827AAF/image-size/medium?v=v2&px=400)
The problem is i have to use text to columns in excel if i want format 12 hour.
Can you please write me a script that can change all the row in columns into 12 hour format?