I have a tricky one. I receive nearly 700 news releases a day, and almost all if them have a line towards the end that says (close to):
"He is the son of Jon and Linda Doe of 14th street, anytown, MS." or "She is the daughter of LInda Smith, of Oak Park Drive, Roanoke, IN."
I need to take the street location out, to make it:
""He is the son of Jon and Linda Doe of anytown, MS." or "She is the daughter of LInda Smith, of, Roanoke, IN."
I thought about looking for the word " SON ", skip to the second " of " and deleting from there to and including the ", ".
To narrow it down, EVERY release that contains the words "Basic Military Training" will have the line, and the others are not quite as important to remove the data from. 90% or more of my posts have "Basic Military Training" in them; and those are the ones I'm concerned with.
If you would like to see some specific examples, I can give you the site's address, but the explanation above pretty much covers it.
Oh- and for further challenge, could I save the removed words in a field named "addy"?