Inhaltsverzeichnis

Split

The function Split() breaks a string separated by a separator.

The function parameters are:

  1. the String to be split
  2. the separator character
  3. the position

The third parameter (position) represents the part that is to be returned as a result. This parameter is optional, if it is not specified, the function automatically returns the first part of the string.

Note: The enumeration starts at zero, i. e.' 0' as third parameter corresponds to the same expression as without third parameter.

Syntax:

Split('String', 'Separator')
Split('String', 'Separator', 'Position')

Samples:

Split('Name1;Name2;Name3', ';')

returns Name1

Split('Name1;Name2;Name3', ';', '0')

returns Name1

Split('Name1;Name2;Name3', ';', '2')

returns Name3