Print Page | Close Window

Regular Expression Validator

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Connelly, Marty
Forum Description: Marty Connelly's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=208
Printed Date: 21 Oct 2017 at 12:52am


Topic: Regular Expression Validator
Posted By: Marty Connelly
Subject: Regular Expression Validator
Date Posted: 10 Jul 2008 at 5:50am
Regular Expressions:

So what are regular expressions? Regular expressions provide tools for developing complex pattern matching and textual search-and-replace algorithms. Ask any Perl developer, and they'll tell you that regular expressions are one of the most powerful utilities available for manipulating text and data. This MDB in a very basic way shows how to use RegExp with Access97. It shows parsing a string and validating a field with regular expressions. How to use regular expressions to break out an area code from a free format phone number and a form to develop and test regular expressions. It also shows parsing a CSV type file with fields seperated by a comma this could be expanded to parse any type of printed report page file. Contains Regular Expressions to validate phone numbers,urls,decimal numbers,email addresses(very simple) and US and Canadian Zip codes.

Download Access 97 : http://www.rogersaccesslibrary.com/forum/uploads/10/RegularExpressions.zip - uploads/10/RegularExpressions.zip



-------------
--

Email: mailto:ua218@VICTORIA.TC.CA - ua218@VICTORIA.TC.CA
or
mailto:martyconnelly@shaw.ca - martyconnelly@shaw.ca



Print Page | Close Window