176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Program or batch file that will convert a flat text file into a SQL query
Sign in to Add to Watch List

IT & Programming > Other IT & Programming

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Jan 17, 2013
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Wed, Jan 16, 2013
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

I need some sort of program or batch file written that will convert a flat text file into a SQL query. The program will need to run on my Windows PC. The text file looks like this:

AAM0180C 7
AAM0181 32
AAM0201C 6
AAM0202 24
AAM0203C 9
AAM0204 12

and I need the SQL query to then look like this:

update products set products_quantity=7 where products_model='AAM0180C';
update products set products_quantity=32 where products_model='AAM0181';
update products set products_quantity=6 where products_model='AAM0201C';
update products set products_quantity=24 where products_model='AAM0202';
update products set products_quantity=9 where products_model='AAM0203C';
update products set products_quantity=12 where products_model='AAM0204';

Sign in or Register to see more

Desired Skills
PHP, DOS, SQL
Job ID: 36908931
 
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 United Kingdom
Professional IT Engineer looking to expand into freelance work.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 36915811  |  Submitted: Jan 16, 2013 14:44 ET 
Proposal SEALED

 Pakistan  |  
Experienced PHP, ASP.Net developer, expertise both in desktop and web application. Expert in database driven application with excellent user...
11
  |  
 4.9   |  Private   |  59 Jobs   |  1 verified credential(s)
Bid ID: 36915601  |  Submitted: Jan 16, 2013 14:38 ET 
Proposal SEALED

Dilip Kumar S.      
Dilip Kumar S.'s identity has been verified.  Learn More
 India
We create Websites, Web Applications, Mobile Web Applications, Ad Serving, Mobile Websites with Stripe Payments Integration. A highly energetic and...
3
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 36913667  |  Submitted: Jan 16, 2013 13:28 ET 
Proposal SEALED

 India  |  
My portfolio has details about my previous works. https://www.elance.com/s/aegansys/portfolio/ Reliable Windows developer (C/C++/C#) with 5 year...
Skills: C, C#, C++
4
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 36913302  |  Submitted: Jan 16, 2013 13:16 ET 
Proposal SEALED

 Ukraine  |  
More than 10 years in software development. Self-motivated and solution oriented professional with broad experience in working with teams across...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 36912303  |  Submitted: Jan 16, 2013 12:47 ET 
Proposal SEALED

 India  |  
My name is Sunil, and I manage a very experienced and well-seasoned team of software engineers. I am excited to have a team with such a great skill...
4
  |  
 4.9   |  $1,203 Earnings   |  5 Jobs
Bid ID: 36911413  |  Submitted: Jan 16, 2013 12:19 ET 
Proposal SEALED

 Ukraine  |  
I am a guru in web and desktop development. I have a long track record of projects in web: - development of websites from scratch; -...
5
  |  
 5.0   |  Private   |  39 Jobs
Bid ID: 36910906  |  Submitted: Jan 16, 2013 12:03 ET 
Proposal SEALED

Chaminda Thilakarathna      
Chaminda Thilakarathna's identity has been verified.  Learn More
 Sri Lanka
More than 10 years of experience gain high quality output. Ready to take challenges of difficult programming tasks. code from begin to end. No...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 36910885  |  Submitted: Jan 16, 2013 12:03 ET 
Proposal SEALED

Andrew Phillips      
Andrew Phillips's identity has been verified.  Learn More
 United Kingdom  |  
Winner
I am a PHP developer based in Cambridge, UK with over 8 years' experience. I specialise in high performance websites and server side optimisation...
3
  |  
 0.0   |  Private   |  0 Jobs   |  2 verified credential(s)
Bid ID: 36910565  |  Submitted: Jan 16, 2013 11:52 ET 
Delivery
Within 1 day
$20.00

 Russia  |  
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 36910498  |  Submitted: Jan 16, 2013 11:51 ET 
Proposal SEALED

Ahmed S.      
Ahmed S.'s identity has been verified.  Learn More
 Egypt  |  
I am a freelancer software developer for more than 10 years. Started my career as a freelancer in developing Windows Desktop applications. In the...
9
  |  
 5.0   |  Private   |  20 Jobs   |  2 verified credential(s)
Bid ID: 36910233  |  Submitted: Jan 16, 2013 11:43 ET 
Proposal SEALED

Jatin M.      
Jatin M.'s identity has been verified.  Learn More
 India
Having 5+ years of experience in a PHP, MySQL, Javascript, Jquery, Prototype, Wordpress, Joomla, Web Services, Data Scraping, CodeIgniter, Kohana,...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 36910205  |  Submitted: Jan 16, 2013 11:42 ET 
Proposal SEALED

Pradip N.      
Pradip N.'s identity has been verified.  Learn More
 India  |  
EXCEL, WORDPRESS, IBM DataPower, WTX, JavaScript, XML, XSLT, Data Extraction, Admin Work, SQL.
6
  |  
 4.9   |  Private   |  18 Jobs
Bid ID: 36910118  |  Submitted: Jan 16, 2013 11:39 ET 
Proposal SEALED
Elance is now an Upwork company.
Upwork is the choise of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »