sed & awk (or Perl) should be the best tools for this kind of task. But it's unix centric and has a bit of learning curve.