Michael, This might work..
Create 4 display only fields and the pattern match to each of them being [0-2][0-9][0-9]. If you wish you could have them as value fields instead of Display only just in case you need to store the values of each separately in the database as well. Have workflow to concatenate these 4 fields to an IP address string but a step before doing that make sure that the LEN() of each of them is 3.. Let me know if this helps you.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Durrant, Michael M. - ITSD Sent: Friday, May 04, 2007 12:28 PM To: [email protected] Subject: IP Address Pattern matching ** Anyone have suggestions for matching an IP address pattern (###.###.###.###) in a Character Field? I could use [0-9][0-9][0-9].[0-9][0-9][0-9].[0-9][0-9][0-9].[0-9][0-9][0-9] - but then I have to enter the address as 010.010.001.001. Thank you for your time, Michael Durrant IT Systems Integration Analyst Division of Information Technology Idaho Department of Health and Welfare Share what you know. Learn what you don't. No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.6.2/787 - Release Date: 5/3/2007 2:11 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
