%%$SUBSTR Function

The %%$SUBSTR function extracts a substring from the input string, and returns the attached substring. Format:

%%$SUBSTR strng startpos len

where:

• strng is the input string from which the substring is extracted.
• startpos is the first character of the input string to extract.
• len is the number of characters to extract.

startpos and len must be numbers (or numeric AutoEdit expressions) and greater than zero.

If (startpos + len – 1) is greater than the strng length, the function is not executed and the value returned is null.