![]() ![]() |
Home |
How it works |
Projects archive |
Contact Us Air Compressor Bot |
|
| The Career Path of Freelance Programming Jobs |
Convert Data into Correct Format |
![]() |
Bidding Time: |
23/07/2008 16:45 - 02/08/2008 00:00 |
Budget: |
$30-250 |
Status: |
Closed |
|
|
|
Job Type: |
|
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 Related Projects: This project is the proprietary information of .
Click here to remove this project from OUR database.
|
Operating System: |
MS Windows |
Database System: |
MS SQL |
| <<< back |
|
| Home | Projects archive | RSS | Resources | Links | Contact Us | © 2004-2008 ProjectsList.biz /0.86 |