Convert Data into Correct Format (PHP, Script Installation)

	Home \| How it works \| Projects archive \| Contact Us Air Compressor Bot
	The Career Path of Freelance Programming Jobs

Bidding Time:	23/07/2008 16:45 - 02/08/2008 00:00
Budget:	$30-250
Status:	Closed

Job Type:	PHP, Script Installation
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 Start your work-at-home career for $7.00. Get direct access to thousands of freelance and home-based jobs. Click here to find work now. Related Projects: FREELANCE CRAIGSLIST AD POSTER Cyberport.at Need a Designer Content management program Fix View On Ie7 For Joomla 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