GetAFreelancer.com
 
Find projectsSearch
Sign Up | Log in | Top Rated Users | Browse projects | Post Project | RSS feeds | Articles
 

Convert Data into Correct Format

   Click here to post similar project

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

Status: Closed (Cancelled by the Site Administrator)
Selected Providers: -
Budget: $30-250
Created: 07/23/2008 at 16:45 EDT
Bidding Ends: 08/02/2008 at 16:45 EDT
Project Creator: babloo786 View PM Post PM
Buyer Rating: 9.89/109.89/109.89/109.89/109.89/109.89/109.89/109.89/109.89/109.89/10
(18 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:
  • PHP
  • Script Installation
Database: MS SQL
Operating system: MS Windows
Bid count: 14
Average bid: $ 73

 

Related project
 
Nonpublic project #343539 Featured Nonpublic
login to view
 

FREE Trial project for new buyers!
 

View Project Message Board     Post Message on Project Message Board
Messages Posted: 0

If you are the project creator or one of the bidders Log in as project creator or bidder for more options

Bid on This Project

Service Providers PMB Bid Delivery Within Time of Bid Provider Rating
NickolaS
View PM Post PM 		$ 50 0 days 07-23-2008 17:03 EDT 9.99/109.99/109.99/109.99/109.99/109.99/109.99/109.99/109.99/109.99/10
(345 reviews)
Hi, please, check your PM
imszone
View PM Post PM 		$ 75 3 days 07-24-2008 01:03 EDT 9.89/109.89/109.89/109.89/109.89/109.89/109.89/109.89/109.89/109.89/10
(95 reviews)
Hi, please see PM.
nitrocube
View PM Post PM 		$ 30 2 days 07-24-2008 20:49 EDT 9.69/109.69/109.69/109.69/109.69/109.69/109.69/109.69/109.69/109.69/10
(16 reviews)
Please check the PM
h114
View PM Post PM 		$ 30 1 day 07-25-2008 05:11 EDT 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(5 reviews)
kindly check pmb.
consus
View PM Post PM 		$ 120 2 days 07-24-2008 15:06 EDT 9.75/109.75/109.75/109.75/109.75/109.75/109.75/109.75/109.75/109.75/10
(4 reviews)
Hello sir Please check your PMB for Bid detail Thanks
esoftbusiness
View PM Post PM 		$ 60 1 day 07-23-2008 23:32 EDT 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(3 reviews)
Hello I am ready to start this work. Please see PMB.
FlashPoint111
View PM Post PM 		$ 30 3 days 07-24-2008 15:10 EDT 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(1 reviews)
Hello sir, I m ready for your project. Please Confirm your PM.
freshjah
View PM Post PM 		$ 40 1 day 07-23-2008 21:47 EDT 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(1 reviews)
Please see PM
sristerweb
View PM Post PM 		$ 30 2 days 07-25-2008 02:48 EDT 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(1 reviews)
I am ready to do this... Bidding for less... to have long time relation...
mfrna
View PM Post PM 		$ 40 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
View PM Post PM 		$ 70 1 day 07-24-2008 04:30 EDT (No Feedback Yet)
I'm a SQL expert. I can do the script for you.
TechTigers
View PM Post PM 		$ 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
View PM Post PM 		$ 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
View PM Post PM 		$ 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

 

[ Outsourcing Web Design ] [ Post Project Free ] [ Website Design ] [ Outsourcing ]

What is GetAFreelancer.com? ( Read about the company )

Outsourcing is hiring an outside organization to perform services such as information processing and applications development. GetAFreelancer.com helps webmasters, web designers, programmers, software developers and business owners to develop their projects. A freelancer is an independent worker, not on salary, hired instead on a project basis. Buy services with help from our secure escrow system. Outsource projects and save a lot of money. Getting affordable freelance work, freelance programming and custom web design done for your website has never been easier. Our site is global and we have freelancers from India, Romania, Russia, Ukraine, United States, UK and many other parts of the world.

Find freelance programmers, web designers, copywriters and translators. Outsourcing is the process of subcontracting network operations and support to an organization outside your own company. Try it free today! Would you like to outsource your next project? Would you like to make money as a freelancer? Click Sign Up to start! We provide a safe escrow environment and you don't release the money until project is completed. Our mission is to find the best possible freelance workers at the best possible price. Bookmark our homepage to make sure you don't forget about our website next time you need to develop an IT project for yourself or your company.

Find Webmaster Resources and Webmaster Forum. Take a look at Search Engine Submission.

Innovate it Innovate it © 2004-2008   PRIVACY POLICY  -   TERMS  -   AFFILIATES  -   CONTACT  -   FAQ   New projects feed by RSS 2.0