Version

UltraCalcFunctionMid Class

Gets a specified number of characters from the middle of a text string, starting from a specified position in that string.
Syntax
'Declaration
 
Public Class UltraCalcFunctionMid 
   Inherits BuiltInFunctionBase
public class UltraCalcFunctionMid : BuiltInFunctionBase 
Remarks

MID(text_value, starting_point, character_count)

Text_value is a piece of text containing the substring you want to retrieve, when you know the position and length of your desired substring.

Character_count specifies how long of a substring to retrieve from text_value measured as a number of characters. If the requested length, when added to the specified starting_point, exceeds the length of text_value then the remainder of the string starting at starting_point is returned.

Starting_point is the one-based position within text_value of the first character in the substring you want to retrieve. If this argument exceeds the length of text_value then the function will return an empty string.

If either character_count or starting_point has a negative value, or evaluate to an error value, then the function returns an error value.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also