mid()

Read(232) Label: string, substring,

Description:

Return the substring of a string.

Syntax:

mid(s,start{,len})

Note:

The function returns a substring of s from the specified position start. The length of the substring is len.

Parameters:

s

The source string from which you get the substring

start

The starting position of the substring

len

The length of substring. By default, the length will be counted from the starting character to the end of the source string

Return value:

A string

Example:

mid("abcde",1)

abcde

mid("abcde",1,2)

ab

mid("abcde",3)

cde

Related functions:

left()

right()