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.
- The text value to be searched.
- 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.
- The text value containing all the possible delimiter characters.
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.
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".