perl with the right plugins makes data janitor situations simplified.