Substring Before function

The Substring Before function extracts all the characters in a string starting at the beginning up to the first occurrence of a specified substring (one or more characters).

Parameter: string

The string to extract a substring from. This can come from a source node, the result of another function, or a value you specify.

Parameter: string

The characters to use as the ending point for the extraction. The first occurrence of these characters is used as the ending point. This can come from a source node, the result of another function, or a value you specify.

Returns: string

The substring in the first parameter starting at the beginning up to the first occurrence of the specified end string. If the end string is not present, this returns an empty string.

Example

substring-before('12/31/1999','/') = '12'



Feedback | Notices


Timestamp icon Last updated: Wednesday, 15 June 2016


http://pic.dhe.ibm.com/infocenter/wci/v7r0m0/topic/com.ibm.wci.doc/ref_SubstringBefore.html