DriveWorks Solo 15: Mid [send feedback...]

Syntax

MID( [ Text], [ Start Number], [ Number of Characters] )

Text is the string of text or a reference to some text .

Start Number is the position of the first character you want to retrieve.

Number of Characters is the amount of characters you want to retrieve from the specified starting position.

To start retrieving characters from the beginning of the text, the Start Number must be set to 1.

The MID function, when calculated, returns a specified number of characters from the chosen starting position.

Examples

Rule

Meaning
MID(ProductCodeTextBoxReturn, 1, 3)The MID function will retrieve 3 characters from the return value of the ProductCodeTextBox, starting at the first character in the text.

Example Outcomes

ProductCodeTextBoxReturn Value

Start Number

Number of Characters

Result of the MID function

"P7100GH"13P71
"WT567LL2"547LL2

Table of Contents