Need Scrip to Convert Database to Upper/Lower Case and Global/Replace

IN PROGRESS
Bids
13
Avg Bid (USD)
$155
Project Budget (USD)
$30 - $250

Project Description:
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) :

foodID
foodType
foodName
Feature1
Feature2
Feature3

SAMPLE RECORD:

100
FRUIT
RED MANGO
JUICY AND SWEET
APPROXIMATELY 5 INCHES
95 CALORIES PER SERVING (CPS)

SAMPLE RESULTS:

100
Fruit
Red Mango
Juicy and Sweet
Approximately 5 Inches
95 Calories per Serving (CPS)

EXPLANATION:

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.

STRUCTURE:
I think this should be pretty simple. Just two tables and 4 pages.

TABLES:
fruits (containg data to modify)
exclusions (contain the words to exclude / replace)

PAGES:
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.

Skills required:
ASP, SQL
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 160
in 5 days
$ 150
in 6 days
$ 150
in 3 days
Hire Codoc1010
$ 120
in 3 days
$ 150
in 7 days
Hire swagatab
$ 150
in 3 days
Hire krishnadubey
$ 50
in 1 days
$ 175
in 5 days
$ 250
in 30 days
$ 150
in 7 days