Contents
Display Legacy Contents

 Print
    Middle  
This Function returns a <string>, which is a substring of the specified Source string, starting at the Starting position, with the specified Length.

Parameters

Source string <string>
  String from where to extract a substring.
 
Starting position <string>
  Starting position in the Source string of the string to extract.
 
Length  <numeric>
  Length of the substring to extract.

     
Example 1
  Example 2   Example 3
Mid("Enjoy Kalipso.", 7, 7)

Result = Kalipso
  Mid("Enjoy Kalipso.", 0, 5)

Result = Enjoy
  Mid("Enjoy Kalipso.", 15, 2)

Result =

         
Example 4  
 
Mid("Enjoy Kalipso.", 7, 10)

Result = Kalipso.

   

     
  • If you specify a Starting position higher than the length of the specified Source string, and empty string will be returned.
  • If you specify a Length higher than the difference between the length of the specified Source string and the specified Starting position, the returned string will be the left part of the Source string, starting at Starting position.

See also
Samples

 
Updated: 3/21/2018 4:26 PM