SUBSTR AFT - Return a sub-string after a sub-string (Reports & Settings Report Generator function)
From Catalyst
Revision as of 11:45, 22 September 2016 by Les Ward (talk | contribs) (Les Ward moved page SUBSTR AFT - Return a sub-string after a sub-string (Reports & Parameters Report Generator function) to SUBSTR AFT - Return a sub-string after a sub-string (Reports & Settings Report Generator function))
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.