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 September 27, 2022