![]() |
|
![]() |
Mid FunctionThe Mid function in Expression Builder returns a specified number of characters from a string. TIP: To determine the number of characters in a string, use the Len function. SyntaxMid(string, start, length) Result TypeString ArgumentsThe following table describes the arguments for the function.
ExamplesThe following example returns seven characters (Builder), beginning with the twelfth character in a string: Mid("Expression Builder is easy!!", 12, 7) The following examples return seven characters, beginning with the twelfth character from a text field that contains the text: Expression Builder is easy!! Mid('<TextFieldName>',12, 7) or Mid([<TextFieldName>],12, 7) The following example extracts the domain name from an email address: Mid([<CreatedbyEmailAddress>],FindOneOf([<CreatedbyEmailAddress>], "@") + 1, Len([<CreatedbyEmailAddress>])) Related InformationSee the following topics for related Expression Builder information: | ||||||||||
Published May 2008 |