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

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchDataCenter

SearchContentManagement

Close