fbpx
Select Page

Returns a substring defined by offset and length.

Usage

Mid(<string>,<start>,<length>)

string (required) The string to extract a substring from.

start (required) The index of the first letter of the extracted substring. The first character of the given string is treated as having index 1.

length (optional) The length of the segment to extract. If length is not given, or if the provided length is longer than the remaining source string, the total remaining string will be returned.

Examples

Mid(“John Doe”, 4, 10)
  • Returns “n Doe”
Mid(“John Doe”, 2, 2)
  • Returns “oh”
Mid(“Mia”, 4)
  • Returns “”, an empty string.

See Also

Find
Left
Right

More About Text Functions

Text functions analyze or manipulate string data and are useful sanitizing string input.

When inputting a string, use quotation marks to indicate it as a string. “This is read as a string”

If you would like to include quotes in your string, you can use a slash \ to indicate the following quote is part of the string. “\”This is a string with quotes\”” will display as “This is a string with quotes”

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.