Closed

CSV file manipulation/change format

This project received 49 bids from talented freelancers with an average bid price of $116 USD.

Get free quotes for a project like this
Employer working
Project Budget
N/A
Total Bids
49
Project Description

We have a csv file which is updated every day. We need to output another CSV using the data in this file, with a different layout and some simple formula applied to the data.

Example import layout:
Product Code, Product, Brand, Category, Price, Unit, Qty, Product Image, EAN

Example output layout:

Product Code, Maximum price (Price*fixed % from config file), Minimum price (Price*another fixed% from config file), Qty, Fixed Text from config file, Fixed Text from config file,

We would like to be able to change the format in the future so a config file would be required. In the config file we would need to be able to match the columns and set them to the output along with any fixed text values or minimum cost percentages etc i.e

Config file:

Set Input file:
Column 1 = Product Code
Column 2 = Product
Column 3 = Brand
Contains headers

Set Output file:
Column 1 = Product code
Column 2 = Price % Fixed percentage

If you can help please place a bid
Thanks

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online