topic Re: Convert character timestamp to typical numeric format in Discussions

Convert character timestamp to typical numeric format

WHG — Thu, 15 Aug 2019 15:44:03 GMT

I would like to convert a character timestamp format like this one:

06/28/19 11:26:29:252

to a typical numeric format

06/28/19 11:26:29

Any help much appreciated.

Re: Convert character timestamp to typical numeric format

johnmoore — Thu, 15 Aug 2019 18:02:04 GMT

Give this a try

characterStamp = "06/28/19 11:26:29:252";

lastPart = ":"||word(4,characterStamp,":");
substituteinto(characterStamp,lastPart,"");

numberStamp = informat(characterStamp,"m/d/y h:m:s")

Re: Convert character timestamp to typical numeric format

WHG — Fri, 16 Aug 2019 09:27:27 GMT

How do I apply the script to convert the old format to the new format, let's say for all values from column 1 to column 2?

Re: Convert character timestamp to typical numeric format

txnelson — Fri, 16 Aug 2019 10:32:46 GMT

The easiest way to do this is to right click on the column header for Column 2 and select "Formula".

Then place the following into the formula window

characterStamp = :column 1;
lastPart = ":"||word(4,characterStamp,":");
substituteinto(characterStamp,lastPart,"");

informat(characterStamp,"m/d/y h:m:s")

Re: Convert character timestamp to typical numeric format

WHG — Fri, 16 Aug 2019 11:21:27 GMT

This leads to this:

Any help much appreciated.

Re: Convert character timestamp to typical numeric format

johnmoore — Fri, 16 Aug 2019 12:47:28 GMT

Almost there. Just change the format of the column to the date/time format you want.

Re: Convert character timestamp to typical numeric format

WHG — Fri, 16 Aug 2019 13:13:28 GMT

Fantastic. Thank you!

Re: Convert character timestamp to typical numeric format

Jeff_Perkinson — Fri, 16 Aug 2019 13:42:52 GMT

You may find value in .