- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Extract Part of the String
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
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Extract Part of the String
myString="12/9/2023 19:05:57:754";
length=Length(myString);
Substr("12/9/2023 19:05:57:754", 1,length-4)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Extract Part of the String
Thank you. It works!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Extract Part of the String
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);
-Jarmo