MID

Returns the specified number of characters from the middle of a text string given the starting position.

Use

MID(text, start_num, num_chars) and replace text with the field or expression to use when returning characters; replace start_num with the number of characters from the left to use as a starting position; replace num_chars with the total number of characters to return.

String Example MID(Division, 3, 4) returns four characters of the Division name beginning with the third character from the left. On a user record, this represents the department code.

Did this article solve your issue?

Let us know so we can improve!