Michael, one other thought - is this something you could pre-populate from Active Directory or some such, or are you looking to add new data?
Rick -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Durrant, Michael M. - ITSD Sent: Friday, May 04, 2007 10:53 AM To: arslist@ARSLIST.ORG Subject: Re: IP Address Pattern matching Thanks for the suggestions Joe and Axton - I think I'm going to take the display-only fields route and concatenate that. Another (much more complex) idea I had was creating a filter API plugin that would provide either a) specific content-based formatting or b) standard regular expressions. If AR System had "standard" (as opposed to their hack of an implementation) regex capabilities, I would be very very very happy. Michael Durrant [EMAIL PROTECTED] Share what you know. Learn what you don't. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Friday, May 04, 2007 10:52 AM To: arslist@ARSLIST.ORG Subject: Re: IP Address Pattern matching 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: arslist@ARSLIST.ORG > 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" 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. ____________________________________________________________________________ ___ 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"
