topic past col in Discussions

past col

NetflixCrow956 — Fri, 09 Jun 2023 16:56:50 GMT

Hello, I would like to copy only the first 8 characters of the rows of the column Material Number in the column 2.

Mark_Bailey — Wed, 13 Apr 2022 12:05:05 GMT

See the character string functions in the JMP documentation or Scripting Index:

The Left( string, number of characters) should work for this case.

Georg — Wed, 13 Apr 2022 16:42:44 GMT

Another way (if you need the first part of the string befor the "-") would be to use the word function,

in a first step you can let JMP create the formula,

and then you need to set the word separating character to "-".