You could also parse the char value and write each octet to an integer field, in which case testing the limits becomes much easier. Each octet is an 8-bit value, comparative operations against an integer for this type of data is much easier with a data type that easily represents the true value. A 3 character string is really 24-bit for single byte characters and up to 48-bit for double-byte characters... This is not the best way to store the data to test it the way you want. Although, if you converted the represented 8-bit value from a string into a character, you could easily test it.
Axton Grams On 5/4/07, Joe D'Souza <[EMAIL PROTECTED]> wrote:
I didn't think of the 000 possibility.. I guess besides checking the length, if you use the solution I suggested earlier, you would need to check these possibilities too and eliminate them.. and then concatenate the 4 values.. Also make sure you think ahead for IP6 and make allowances for that too.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Axton Sent: Friday, May 04, 2007 12:37 PM To: [email protected] Subject: Re: IP Address Pattern matching Not only that, you could enter 900.999.123.000. There are perl libraries that are very good at this. If you don't want to go that route, you could parse the octets into separate fields, then check those. There was also a thread a couple of months back that had a very very long qual that could be used to evaluate the value. Axton Grams On 5/4/07, Durrant, Michael M. - ITSD <[EMAIL PROTECTED]> wrote: > ** > > 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. > ---------------------------------------------------------- > > > > > The information contained in this email may be privileged, confidential or > otherwise protected from disclosure. All persons are advised that they may > face penalties under state and federal law for sharing this information with > unauthorized individuals. If you received this email in error, please reply > to the sender that you have received this information in error. Also, > please delete this email after replying to the sender. > __20060125_______________________This posting was submitted > with HTML in it___ ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.6.2/787 - Release Date: 5/3/2007 2:11 PM 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"
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
