MID (PQL - xl)

This function returns the requested number of characters from a text string starting at the position you specify, and based on the number of characters you specify

  • Library: PQL \ Spreadsheet \ Text
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
  • Solve: This function can be used with the Solve plug-in: both as part of the objective function and constraint functions

Syntax

MID(text, start num, num chars)

Function Arguments

Name

Description

Type

Optional

text

Text string containing the characters you want to extract

String

start num

Number representing the first character you want to extract in text, with the first character in the text having a value of one (1); if not an integer, the number is truncated

Number

num chars

Number of characters to return from text; if not an integer, the number is truncated

Number

Comments

This function is the same as the Microsoft Excel 'MID' function - using the same inputs, logic and outputs.