Käynnissä

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

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.

Taidot: ASP, SQL

Näytä lisää: what is sql coding, what is record in data structure, what are databases and what are they used for, use case simple example, thanks letter sample, old database, notice letter, letter of notice, letter of explanation, data structure coding, convert $50, clear search fields, 4 letter word for in search of, upper sql, old letters, juicy, global solution, Convert Database, asp classic replace, proper letter, words upper case, selected records, classic asp table search, convert sql database, things need modify

About the Employer:
( 7 reviews ) Huntington Beach, United States

Projektin tunnus: #4251997

Myönnetty käyttäjälle:

swagatab

Hello, I have 12 years of experience and have worked extensively in Classic ASP. I will be happy to take up your project. The have gone through your requirements and have understood it. Just a couple of queries: Lisää

150 $ USD 3 päivässä
(4 arvostelua)
3.0

13 freelanceria on tarjonnut keskimäärin 155 $ tähän työhön

shmai

have a glance at Pm. regards, shmai

160 $ USD 5 päivässä
(167 arvostelua)
6.8
sandeep25101982

Hi [url removed, login to view],MVC,WCF and WPF and Mobile Application Expert here. Please have a look private message for relevant work done. Thanks

150 $ USD 6 päivässä
(25 arvostelua)
6.0
samitXI

Please check your inbox. Thanks

150 $ USD 3 päivässä
(3 arvostelua)
4.3
Codoc1010

Hi, my team has many expert programmers on .NET framework, C++, Sql Server 2005/2008. I sure, we can do your job on time with high quality. Please view my message for detail. Thanks!

120 $ USD 3 päivässä
(12 arvostelua)
4.2
prakashmondal

Hi, I am interested to develop an application to make correct case of your data in database globally.

150 $ USD 7 päivässä
(2 arvostelua)
4.2
krishnadubey

Hello, I'll be happy to create script to convert uppercase and lowercase of data. Regards, Krishna

50 $ USD 1 päivässä
(5 arvostelua)
2.5
ultrasonicsoft

Hi, I am very good in ASP.NET and SQL Server 2008 R2. I can do this task. Please check my profile for more details. Thanks!

175 $ USD 5 päivässä
(1 arvostelu)
1.9
ramdular20

Hi, I am JAVA expert and can surely help you here, Please share complete details.

250 $ USD 30 päivässä
(0 arvostelua)
0.0
bap0nC

please check my pm

80 $ USD 5 päivässä
(0 arvostelua)
0.0
cigara9393

Hi, I'm ready for this project. Please see you PMB.

150 $ USD 7 päivässä
(0 arvostelua)
0.0
rathinam77

Ready to take this.

225 $ USD 4 päivässä
(0 arvostelua)
0.0
tomgough79

over 10 years experience in SQL Server and web applications. I have direct experience with the type of data cleansing you are looking to complete

200 $ USD 5 päivässä
(0 arvostelua)
0.0
bezira

Hello, I have been a database developer for more than 13 years and am extremely experienced in SQL. I have been a web designer/developer for 13 years and therefore have been using classic asp since the beginning of tha Lisää

150 $ USD 2 päivässä
(0 arvostelua)
0.0