cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
JMP_9006
Level I

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
hogi
Level XIII

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)
JMP_9006
Level I

Re: Extract Part of the String

Thank you. It works!

jthi
Super User

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

Recommended Articles