Related Topics: | ||
Description: Returns a specific number of characters from a text string, starting at the position you specify.
Syntax: MID(Text, Start_num, Num_char)
Text is the text string containing the characters you want to extract.
Start_num is the position of the first character you want to extract in Text. The first character in Text has Start_num 1, and so on.
Num_char specifies the number of characters you want MID to return from Text.
Remarks:
If Start_num is greater than the length of Text, MID returns "" (empty text).
If Start_num is less than the length of Text, but Start_num plus Num_char exceeds the length of Text, MID returns the characters up to the end of Text.
Start_num must be greater than 1.
Num_char must not be negative.
Example:
MID("Fluid Flow", 1, 5) = Fluid [five characters from the string, starting at the first character]
MID("Fluid Flow", 7, 20) = Flow [twenty characters from the string, starting at the seventh character]
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.