Completed

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

This project was successfully completed by swagatab for $150 USD in 3 days.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$30 - $250 USD
Completed In
3 days
Total Bids
13
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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online