substring-before
Use this function to extract a substring from a string. The substring to be extracted appears before the first occurrence of a specified substring.
Note: This function is only supported by the CDC Replication Engine for Event Server.
- Syntax:
- substring-before(value, searchSubstring)
- Input Parameters:
- value represents an input value: an expression, a literal, or a function.
- Return Value:
- String
- Example:
<sxt:element name=AreaCode
value=substring-before(Phone, ` `)
/>