The MID function selects a portion of the string to display beginning at value 1 characters from the left of the string for value 2 characters into the string. Value 2 is optional. If value 2 is not supplied, the function returns all remaining characters. This function is only applicable for alphanumeric cells.
Syntax
MID(expression, value 1<,value 2>)
-
Example
MID("Prince Edward Island",8,6)
Where 8 characters into the string is the E of Edward and 6 characters from the E of Edward is the last D of Edward. Therefore, the cell displays Edward.
Database Filter Syntax
MID(DATABASE -> FIELD, number), OPERATORVALUE
-
Example 1
- MID(GL->JE_DESC,20,4)="BANK"
- Returns all journal entries that have, and match exactly, the four letters "BANK." at the 20th position counted from the left side in the journal description.
-
Example 2
MID(LTRIM(AM->AC_NO),5,2)="22"
Returns all accounts with account numbers that have "22" in the 5th position from the left.
