CSV file manipulation/change format

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


Skills: Data Processing, Excel, MySQL, PHP, Website Testing

See more: minimum unit cost, minimum cost, cost format, format price, format layout, csv file, text manipulation, csv product import, data set formula, csv column format, change column, cost file, csv text file, php output csv, csv file input, csv data manipulation, simple percentage formula, csv file code, config file simple, ean code, import product file, product import file, csv manipulation, import product csv category php, processing csv

About the Employer:
( 83 reviews ) Eghm, United Kingdom

Project ID: #4422894

45 freelancers are bidding on average $117 for this job


We are a team of web developers with expertise and experience in PHP and MySql. We have delivered successfully on many custom applications. I have read the project requirements and I am confident of delivering very More

$262 USD in 3 days
(821 Reviews)

HI, I am ready to build such a csv processing script. best quality assured. Thanks

$185 USD in 3 days
(738 Reviews)

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$99 USD in 2 days
(236 Reviews)

I can create script to handle csv file, manipulate and output calculated data. I will be complete this work in 2 days.

$64 USD in 2 days
(537 Reviews)

Quality work assured. Ready to get started. Thanks.

$200 USD in 1 day
(374 Reviews)

Hello, I have think about the solution and I'm close. Will need to follow some rules to config each column. Some symbol or brackets will be used. I'm sure the script can be done by me. But if you want more calcul More

$150 USD in 3 days
(226 Reviews)

Hi ready to start Thanks

$156 USD in 5 days
(145 Reviews)

Hello. I worked with CSV/XML files before. I can help you with this job. Regards, Daniel!

$220 USD in 3 days
(88 Reviews)

Hello, Excel VBA expert here. I've completed similar projects. Please check PM for details. Thanks!

$165 USD in 3 days
(62 Reviews)

I have completed many projects like this that's why I'm sure you'll be impressed with my work. See PMB for details.

$50 USD in 1 day
(160 Reviews)

Hello Sir, can delever the exact script you are looking for. Please check the PMB

$140 USD in 2 days
(77 Reviews)

Hello, Can make this. So you have some php-script which operate with csv. Need to see this script. Have big experience working with csv. Regards. Dima

$84 USD in 2 days
(52 Reviews)

pls tell me your site ftp info and job details. then i will work immediately. Thx.

$105 USD in 5 days
(73 Reviews)

Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet co More

$95 USD in 3 days
(38 Reviews)

Consider it done. Check your PM for my bid details.

$198 USD in 3 days
(50 Reviews)

I can give u simple windows application which will take the csv file as input and give u output csv file the format and calculations you require. You can get it with simple windows click If you want a windows applic More

$75 USD in 1 day
(19 Reviews)

hi i am very good in php and i have done similar work earlier... i can take the input and manipulate it get the required output... and the system can be make quiet flexible. kindly have a look at my reviews for re More

$80 USD in 1 day
(32 Reviews)

Hi, I can do it. I'm a programmer for years and very familiar with VBA for excel. I've done similar project to convert from one structure file into another one (columns mapping) with any kind of manipulation (computati More

$110 USD in 3 days
(21 Reviews)

Hi, I can do the job, I can develop a script for do that, software developer for a several years, expert in automation Regards Diego

$100 USD in 2 days
(15 Reviews)

Hello, I have over 8 years experience in web developing. I can do this job. Please feel free to ask if you have any questions. Thank You

$40 USD in 1 day
(36 Reviews)