Split Function

This function splits the input text into separate parts around a given separator and returns one of the parts specified by parameter occurrence. If several or all parts are required, the Split function has to be used several times with different values for each occurrence.

Input consists of one input field.

Parameters

Separator The text around which the input is split. Enter #space for a blank value (" ").
Occurrence In the list of computed parts, the index of the text part that should be returned
Default The return value if fewer text parts are found in the input than requested by parameter occurrence.

Examples

Updated March 27, 2024