I need help updating an old database that is in ALL-CAPS and converting it to
proper upper/lower case. The script should be easy for me to modify, add, edit
which fields are going to be converted and also allow me to globally replace
specific values within the fields.
EXAMPLE TABLE (food) :
JUICY AND SWEET
APPROXIMATELY 5 INCHES
95 CALORIES PER SERVING (CPS)
Juicy and Sweet
Approximately 5 Inches
95 Calories per Serving (CPS)
If you notice in the 'SAMPLE RESULTS', there are a few things I am looking for and these can be done in several stages. It does not need to be a single-pass solution. For the most part, the first letter of each word should be capitalized and the remaining letters will be lowercase; however, small words (if, per, to, with...) should not be capetilized. Perhaps there should be a table that I can enter these words into and they would be the 'exclusionTable' and all the words there would not be changed.
I will also need to be able to change specific words or text globally. For example, the 'CPS' in the 'SAMPLE RECORD' above would initially be translated to 'Cps' which is not quite right so I would then use a 2nd page that would allow me to select a field, value to search/replace.
This needs to be done in classic .asp because that is what I am most familiar with and will need to use this for several different databases; so, it should be easy to modify and clear coding should be used. The tables that I will be using this on may have 50 fields but I will only be updating about 10 fields per table.
I think this should be pretty simple. Just two tables and 4 pages.
fruits (containg data to modify)
exclusions (contain the words to exclude / replace)
search (allow me to search for the records to be modified and/or words to replace)
enterExclusions (enter the words to exclude / replace with)
results1 (allow me to review the records and then click 'convert' and all the records would be converted to propercase)
results2 (allow me to review the records with selected exclusion word, click 'convert' and all of the selected records would be changed)
Thanks for considering this project.