SUBSTR BEF - Return a sub-string before a sub-string (Reports & Settings Report Generator function)
From Catalyst
Syntax
$SUBSTR_BEF{string, substr, count, len}
Description
Extract a sub-string from a string before a sub-string.
$SUBSTR_BEF{"Catalyst Computer Systems Ltd","Com",1,6} Will return "alyst ". |
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.