Project Detail

Convert Data into Correct Format

Convert Data into Correct Format is project number 291134
posted at Freelancer.com. Click here to post your own project.

| More

Status: Cancelled

Selected Providers: -

Budget: $30-250

Created: 07/23/2008 at 16:45 EDT

Bid Count: 14

Average Bid:
$ 73

08/02/2008 at 16:45 EDT

Project Creator: babloo786 offline
Employer Rating: 9.9429/10 (35 reviews)

Description

I have million of data in the database. There are many mix data in the column so I need you to create a PHP script or SQL statements that will convert these data into correct format.

If there is any other error, print the row number so I can fix it manually.

I am running on MS SQL server.

1)Check and change the date into right date/time format
Ex.
Aug/1/98
August/01/98
Aug/1/1998
01/01/98
01/01/1998

2)Check and change SSN into 123456789
Ex.
888-88-8888
88-52-5214
543-45-54

3)Check and change the phone number into 123456789
Ex.
(909) 885-5255
909-888-5256

After all the data have covert into correct format in the database. I need you to write simple PHP codes that will convert these:

SSN – 123456789 to 123-45-6789
Phone – 9098885896 to (909) 888-5896

Report Violation

Job Type

See more: convert, create, data, date, fix, format, number, phone, phone number, php, php script, print, script, simple, simple php, sql, sql server, write

Messages Posted:0

If you are the project creator or one of the bidders Log In for more options

PMB

0 days

07-23-2008 17:03 EDT

9.9899/10
(395 reviews)

Hi, please, check your PM

imszone offline

3 days

07-24-2008 01:03 EDT

9.9324/10
(148 reviews)

Hi, please see PM.

sristerweb offline

2 days

07-25-2008 02:48 EDT

9.9412/10
(102 reviews)

I am ready to do this... Bidding for less... to have long time relation...

nitrocube offline

2 days

07-24-2008 20:49 EDT

9.7222/10
(18 reviews)

Please check the PM

consus offline

120

2 days

07-24-2008 15:06 EDT

9.7778/10
(9 reviews)

Hello sir Please check your PMB for Bid detail Thanks

h114 offline

1 day

07-25-2008 05:11 EDT

9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10
(6 reviews)

kindly check pmb.

FlashPoint111 offline

3 days

07-24-2008 15:10 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(4 reviews)

Hello sir, I m ready for your project. Please Confirm your PM.

esoftbusiness offline

1 day

07-23-2008 23:32 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(3 reviews)

Hello I am ready to start this work. Please see PMB.

freshjah offline

1 day

07-23-2008 21:47 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(1 reviews)

Please see PM

mfrna offline

3 days

07-24-2008 01:24 EDT

(No Feedback Yet)

can do the job,please send me more details if interested. Thank you

silmarx offline

1 day

07-24-2008 04:30 EDT

(No Feedback Yet)

I'm a SQL expert. I can do the script for you.

TechTigers offline

100

1 day

07-24-2008 05:06 EDT

(No Feedback Yet)

Hi there, My partner and I are english based freelance web programmers, we both graduated this year and are looking to build a customer base for our freelance business. We have huge experience in php,sql,ajax,javascript. We own several online games, recently did some work for Kelloggs (cereal company) designing a new website for the Kelloggs Yogo (a new cereal bar aimed at kids). We look too both give the best solution while also hopefully devleoping a lasting relationship with yourself. Which benefits us both. Hope to here from you soon. Cheers Dave

jayknite offline

100

4 days

07-25-2008 14:19 EDT

(No Feedback Yet)

The conversion sounds straight forward. I do all my work in php and mysql/mssql.

usman87 offline

250

10 days

07-24-2008 20:32 EDT

(No Feedback Yet)

hello i am interested in your this project.. please see ur PMB Thanx

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.