The 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.
Mid(string, start, length)
The following table describes the arguments for the function.
The 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!!
The following example extracts the domain name from an email address:
Mid([<CreatedbyEmailAddress>],FindOneOf([<CreatedbyEmailAddress>], "@") + 1, Len([<CreatedbyEmailAddress>]))
See the following topics for related Expression Builder information:
|Published 5/4/2012||Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.|