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
Text string containing the characters you want to extract
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 of characters to return from text; if not an integer, the number is truncated
This function is the same as the Microsoft Excel 'MID' function - using the same inputs, logic and outputs.