What is the nature of this data - a flat file?

And you want to clean the data as part of an import to a db - is that right?