Mid Function

The Mid function returns a specified number of characters from a string. The Mid function returns the portion of the designated string for a designated length starting from any position in the string. The Function will return the requested number of characters from a string. The Length of Characters To Pull parameter is optional.

It explains the Two Mandatory Arguments :-

• String :- The String argument is the name of the string you wish to abbreviate. The string expression from which characters are returned. If string contains Null, Null is returned.
  
  
• Start :- The Start argument is a numeric position anywhere in the string counting from the left side. The portion of the string to the left of this position will be discarded. The character position in string at which the part to be taken begins. If start is greater than the number of characters in string, Mid returns a zero-length string ("")
  
  

It explains One Optional Argument :-

• Length :- The optional Length argument is the number of characters (including blanks) in the string you wish to save counting from the position designated by the Start argument.

The Syntax of the Mid function is :-

Example#1 :-

Example#2 :-

Example#3 :-

Example#4 :-

Example#5 :-

Example#6 :-
It explains the Start argument

Example#7 :-
It explains the length argument

Notes :- The MidB function is used with byte data contained in a string. Instead of specifying the number of characters, the arguments specify numbers of bytes.