Manage Learn to apply best practices and optimize your operations.

Validating A Phone Number The Easy Way.

Not too many people use the @Match function, but it is really cool. Here is how
I validate a telephone number to be in the following format:
(999) 999-9999.
Put this code in the validation formula of a field. Of course replacing the
name of your field for the one in the example. It is a short and sweet
function. You can do all sorts of things with it. Use it to validate ssn #s
too. If you want to check for letters use {A-Z} or {a-z}.
@If(@Matches(PhoneNumberfield;"{(}{0-9}{0-9}{0-9}{)}
{0-9}{0-9}{0-9}-{0-9}{0-9}{0-9}{0-9}");@Success;@Failure("Please enter the
telephone number in the following format: (999) 999-9999"))

Dig Deeper on Lotus Notes Domino Administration Tools

SearchWindowsServer
Search400
  • Favorite iSeries cheat sheets

    Here you'll find a collection of valuable cheat sheets gathered from across the iSeries/Search400.com community. These cheat ...

SearchDataCenter
SearchContentManagement
Close