SUBSTR or SUBSTRING macro
The SUBSTR or SUBSTRING macro is available in IBM® Campaign and IBM® Interact.
Syntax
SUBSTR(string_value, start_pos[, nchars]) or SUBSTR(string_value FROM start_pos[ FOR nchars]) SUBSTRING(string_value, start_pos[, nchars]) or SUBSTRING(string_value FROM start_pos[ FOR nchars])
Parameters
string_value
The string from which a substring will be taken.
start_pos
The starting character from each substring will be extracted.
nchars
The number of characters to be extracted (must be greater than or equal to 0). If this value is not provided, all remaining characters in string_value are extracted.
Description
SUBSTR or SUBSTRING extracts nchars characters from the string, starting at start_pos. If nchars is omitted, SUBSTR and SUBSTRING extracts characters from start_pos through the end of the string. Trailing spaces are automatically truncated. To avoid syntax errors, be sure to separate numeric values with a comma and a space, as shown in the examples.
*
IBM® Interact supports the following formats only: SUBSTR(string_value, start_pos[, nchars]) or SUBSTRING(string_value, start_pos[, nchars])
Examples
SUBSTR SUBSTR Returns
("abcdef" FROM 1 FOR 2) ("abcdef", 1, 2) 'ab'
SUBSTR SUBSTR Returns
("abcdef" FROM -2 FOR 4) ("abcdef", -2, 4) 'a'
SUBSTR SUBSTR Returns
("abcdef" FROM 3) ("abcdef", 3) 'cdef'
Copyright IBM Corporation 2015. All Rights Reserved.