Simple tool/steps for obfuscating/scrubbing production data

I am involved in a project where I need to provide subset of our production da开发者_C百科ta (for a date range) to one of my co-workers for trouble shooting.I would like to insert a scrubbed subset of the production data into a new database table that my co-worker can access. Please suggest best approach to achieve this.

The simplest way is to update the data after copying it to a new table to something that meets enough criteria forit to still be used.

We have a function that does a replacement of letters by letters, spaces by spaces for textual data, and randomised number for numbers.