You know, I started poking around and vfp now has a foundation class (probably written by Craig) for regular expressions. I'm going there first. If that doesn't look promising, I'll take a look at your suggestion.
Thanks, John -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Kaye Sent: Thursday, May 10, 2007 1:51 PM To: [email protected] Subject: Re: Regular Expression? I've recommended this shareware tool here before. It's called RegExBuddy. The cost is nominal. In addition to a very useful IDE for testing out RegEx expressions, it comes with a nice library. (And extensive help, etc.) Here's the expression to match social security numbers from the library that comes with it - \b[0-9]{3}-[0-9]{2}-[0-9]{4}\b Craig Boyd (anyone heard from Craig lately?) wrote a VFP FLL that implements regex and works very nicely for something like this. john harvey wrote: > I have been given a task to remove social security and driver's license > numbers, as well as convert exact addresses to 100 block of whatever that is > contained in a free form narrative. These narratives are police reports that > are being downloaded by the media in the Memphis area. The MPD doesn't want > to send these reports with the above information, but to obfuscate that > portion of the narratives. I've already gotten the code working on the > addresses, but was thinking maybe regular expressions would work well with > detecting and converting the ssn to XXX-XX-XXXXX and maybe even the driver's > license numbers the same way. One small problem is that I have never used > them. Anyone gotz any code that might help on this? > > Thanks, > > > John Harvey > Memphis Police Dept > Technical Consultant > -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001 For the fastest response time, please send your support queries to: Technical Support - [EMAIL PROTECTED] Australian Support - [EMAIL PROTECTED] Internet Support - [EMAIL PROTECTED] All Other Requests - [EMAIL PROTECTED] --------------------------------------------------------- This message has been checked for viruses before sending. --------------------------------------------------------- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@shelbynet.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

