When setting up a Custom Object text field, can I require a specific format for the field?

Environment:

Custom Objects, Field patterns

Resolution:

Yes, you can type a regular expression string pattern to define a format that will be used to verify the contents of the field. The carat (^) character is automatically added to the start of the pattern and the dollar sign ($) character is automatically added to the end. This ensures that strings entered in the custom object's field match the entire regular expression.

For example, if you want to create a field to store phone numbers in a format of 123-456-7890, enter a pattern of [0-9]{3}-[0-9]{3}-[0-9]{4}. Refer to Regular Expressions.

Another example, if you want to create a field with a format M732-13EN1, enter a pattern of ([A-Z][0-9][0-9][0-9]-[0-9][0-9][A-Z][A-Z][0-9]).

For additional information, refer to the 'Adding a field to a custom object' section in the Online Help User Guide documentation for the version your site is currently running. To access Oracle B2C Service manuals and documentation online, refer to the Documentation for Oracle B2C Service Products.