Search

 

Module: Editor

Version: 2.2.1 +

Type: String

Category: Text

 

Description

The formula 'Mid' returns the characters from the middle of a text string, given a starting position and length.

Parameters

Text:                       this is the text string from which you want to extract the letters.

Start_num:              this is the position of the first character you want to extract, The first character in 'Text' is 0.

Num_chars:             this specifies how many characters to return from 'Text'.

Example

Description

In the following example you can see how the formula 'Mid' works.

Values parameters

Text:                       Dear Mr.

Start_num:              5

Num_chars:             3

Result

Output:                   Mr.

Related Topics

Right: The formula 'Right' returns the specified number of characters from the end of a text string.

Left: The formula 'Left' returns the specified number of characters from the start of a text string.

Feedback

If you have any questions about this subject or if you want to provide us feedback please send us an e-mail.

Updated: 2014-09-25