topic Extract Part of the String in Discussions

Extract Part of the String

JMP_9006 — Tue, 12 Dec 2023 20:29:31 GMT

Hello,

I have a string and I want to extract everything but the last four characters of the string.

So, the following string,

12/9/2023 19:05:57:754

would results in,

12/9/2023 19:05:57

How do I do this in JMP

hogi — Tue, 12 Dec 2023 20:32:35 GMT

myString="12/9/2023 19:05:57:754";
length=Length(myString);
Substr("12/9/2023 19:05:57:754", 1,length-4)

JMP_9006 — Tue, 12 Dec 2023 20:49:37 GMT

Thank you. It works!

jthi — Wed, 13 Dec 2023 07:23:27 GMT

Other simple option is to use Left()

Names Default To Here(1);

str = "12/9/2023 19:05:57:754";
res = Left(str, Length(str) - 4);

and if you really want to get the date and time without milliseconds (not string without last 4 characters) you can also use Word

Names Default To Here(1);

str = "12/9/2023 19:05:57:754";
res = Word([1 -2], str, ":");

or left with contains to get last ":"

Names Default To Here(1);

str = "12/9/2023 19:05:57:754";
res2 = Left(str, Contains(str, ":", -1) - 1);