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
myString="12/9/2023 19:05:57:754";
length=Length(myString);
Substr("12/9/2023 19:05:57:754", 1,length-4)
Thank you. It works!
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);