Difference between revisions of "SUBSTR AFT - Return a sub-string after a sub-string (Reports & Settings Report Generator function)"
From Catalyst
(Updated from revision control) |
|||
Line 29: | Line 29: | ||
Will return the extracted string. | Will return the extracted string. | ||
− | [[Category:Reports & | + | [[Category:Reports & Settings Report Generator functions]] |
Latest revision as of 13:05, 22 September 2016
Syntax
$SUBSTR_AFT{string, substr, count, len}
Description
Extract a sub-string from a string after a sub-string.
$SUBSTR_AFT{"Catalyst Computer Systems Ltd","Com",1,6} Will return "puter ". |
Parameters
- string
- A text parameter that can not be omitted.
- Input Text.
- substr
- A text parameter that can not be omitted.
- Subtext to search for.
- count
- A numeric parameter that can be omitted (it defaults to "1").
- Number of subtext to find.
- len
- A numeric parameter that can be omitted (it defaults to "90").
- The maximum number of characters to extract from the starting position.
Returns
A text value. Will return the extracted string.