Part(Text text, Numeric position, Text delimiter)

Returns the specified part of a text value. The parts are separated by the occurrence of any delimiter character.

Parameters

text

The text value to be searched.

position

The numeric position of the part in the text. The first part starting on the left is position 1. Negative position numbers can be used to start from the right.

delimiter

The text value containing all the possible delimiter characters.

Returns

Text

Remarks

If a space is included in the delimiter list, it is handled specially. It acts as a delimiter, but contiguous spaces surrounding a delimiter are ignored, rather than each acting as a separate delimiter.

Examples

• Part("model/year/car", 1, "/") returns "model".
• Part("model/year/car", -1, "/") returns "car".
• Part("model/year/car", 3, "/") returns "car".
• Part("model/year/car", 4, "/") returns a blank value.
• Part("David Neil Evans", 2, " ") returns "Neil".