SUBSTR or SUBSTRING macro
The SUBSTR or SUBSTRING macro
is available in Unica Campaign and Unica 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.
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' |