Cleansing Data - TechRepublic
General discussion
December 2, 1999 at 04:01 AM
awillenborg

Cleansing Data

by awillenborg . Updated 25 years, 8 months ago

I have a nightly feed coming from an Oracle Database. The data is all in caps and I would like to run a script which will reformat the data in a presentable format (upper and lower case). The fields include name, address, phone number.

If someone has a list of all the exceptions I need to include in my script that would be helpful.
(Example: DiNiro, Mary-Beth)

This discussion is locked

All Comments