For the latest version of JMP Help, visit JMP.com/help.

HEX( binary )
JLEFT( string, len, <pad> )
Like the JSL Left() function. Returns len characters from the beginning of string. If pad is specified and fewer than len characters are present in string, the result is padded with pad out to length len.
JRIGHT( string, len, <pad> )
Like the JSL Right() function. Returns len characters from the end of string. If pad is specified and fewer than len characters are present in string, the result is padded with pad at the front out to length len.
LENGTH( string )
SQLite equivalent of the ANSI standard CHAR_LENGTH() function. Returns the length of its string argument in characters.
LOCATE( string1, string2 )
POSITION( string1, string2 )
Returns the (1-based) starting position of string1 within string2, returning 0 if string1 is not found within string2.
LOWER( string )
Returns a copy of string with all uppercase characters converted to lowercase.
LTRIM( string, <trimchars> )
Trims any characters contained in trimchars from the beginning of string and returns the result. If trimchars is omitted, spaces are trimmed.
PRINTF( format, <arg1, ..., argN> )
REPLACE( string, find, replace )
Replaces all instances of find in string with replace and returns the result. If replace is numeric, it is converted to a string.
REVERSE( string )
Returns a copy of string with the order of the characters reversed.
RTRIM( string, <trimchars> )
Trims any characters contained in trimchars from the end of string and returns the result. If trimchars is omitted, spaces are trimmed.
SPACE( length )
Returns a string consisting of length space characters.
SUBSTR( string, start, <length> )
Returns the substring of string starting at start (1-based) that is length characters long. If length is omitted, the substring starting at start and continuing to the end of string is returned.
TRIM( string, <trimchars> )
Trims any characters contained in trimchars from the end of string and returns the result. If trimchars is omitted, spaces are trimmed.
UPPER( string )
Returns a copy of string with all lowercase characters converted to uppercase.

Help created on 3/19/2020