Function Index

SplitPart

Splits the string with the given delimiter and returns the nth part.

Usage

SplitPart(<string>,<delimiter>,<position>)

string (required) The source string to be split.

delimiter (required) The string to split with.

position (required) The index of the part to return. When searching the string for the delimiter, the string is broken into parts each time the delimiter is found. These parts are numbered from left to right, starting with 1. Negative numbers for the index will start counting the index from the right.

Examples

SplitPart("index1 index2 index3 index4", " ", 3)
  • Returns “index3”
SplitPart("quick brown fox", " ", 1)
  • Returns “quick”
SplitPart("quick brown fox", " ", -1)
  • Returns “fox”
  • A negative position starts counting the index from the right.