Description
Extracts a given number of characters from a Text, starting at a given position.
Syntax
MID(Text to Extract, Starting Position, Number of Characters)
Arguments
| Argument | Type | Dimensions | Description |
|---|---|---|---|
| Text to Extract (required) | Text | Any Dimensions | Text to extract characters from. |
| Starting Position (required) | Integer | No Dimension or Dimensions of Text to Extract | Starting position of Text to Extract to extract characters from. |
| Number of Characters (required) | Integer | No Dimension or Dimensions of Text to Extract | Number of characters to extract from the Starting Position. |
Returns
| Type | Dimensions |
|---|---|
| Text | Dimensions of Text to Extract |
Extracted characters from Text to Extract.
BLANK if Starting Position is a negative integer or 0.
BLANK if Number of Characters is a negative integer.
Examples
| Formula | Result | Description |
|---|---|---|
MID(“abc”, 3, 1) | “ab” | Starting from the third character, one character is extracted. |
MID(“abcde”, 2, 3) | “bcd” | Starting from the second character “b”, the next three characters are extracted. |
MID(“a”, -1, 1) | BLANK | The Starting Position, -1, is invalid. |
MID(“a”, 1, -1) | BLANK | The Number of Characters, -1, is invalid. |
See also
Excel: MID
More of a hands-on learner?
Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!
