- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
past col
Hello, I would like to copy only the first 8 characters of the rows of the column Material Number in the column 2.
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: past col
See the character string functions in the JMP documentation or Scripting Index:
The Left( string, number of characters) should work for this case.
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: past col
See the character string functions in the JMP documentation or Scripting Index:
The Left( string, number of characters) should work for this case.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: past col
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 "-".
Georg