Closed

Convert .csv into different format .csv

I need a batch file that can be scheduled as a task. This batch file would pick up any .csv (See "Input") files in a specified directory (Directory A), change the files into the format of "[login to view URL]".

Some of the work is a simple remapping exercise (I have colour coded the input and output files to show which are a match), but there are 2 special exceptions:

Customer ID.

The Customer ID must be taken from "Input", looked up in the "lookup" sheet and the corresponding value written into the "Output" sheet.

Product Code/Sku

The same principle here. The value must be looked up in the lookup sheet and returned into the written output file.

There will be a few more tweaks before it can work, but I would be interested to hear whether this can be done and the estimated cost.

I am open to other suggestions for a solution, but the result must be a .csv in the "Output" format and must be able to check the directory every 5 mins for new files.

I have changed the file format in the attached to retain colour coding, but they are .csv files.

Skills: Powershell, Shell Script

See more: easy convert mla format, convert flv format dvd player can view, add format csv file, format csv files need upload outlook, convert rss feed csv, format csv fields excel, convert tab delimited format csv format mac, convert address book csv file format, perl script convert xml document csv format linux, convert sql data csv format, convert db details csv format asp code, convert idoc data csv format sap, convert text file csv format python, convert idoc format csv format, convert data xml csv format, convert xps file csv format

About the Employer:
( 7 reviews ) Edinburgh, United Kingdom

Project ID: #18915565

13 freelancers are bidding on average £93 for this job

kaloyan13

I can do your task in Bash or Python. If your records have commas in the columns its better to use Python.

£30 GBP in 1 day
(164 Reviews)
6.3
venkat071292

Greetings, I have vast experience in Powershell scripting. Please check my profile for my previous clients comments Waiting for you ping.

£44 GBP in 2 days
(27 Reviews)
4.7
romanapanovich

Hi Yes, of course it is doable but if You use windows there are some difficulties with scheduling. But it is doable. Regarding using powershell - please clarify to me - will it be some special named file? Or group of More

£50 GBP in 3 days
(1 Review)
3.8
tangramua

Hello! I can help you to create a batch file that will convert .csv into different format .csv. As for me I'm a professional web developer with 15+ years of experience. My main specialization is LAMP (Linux, Apac More

£150 GBP in 3 days
(2 Reviews)
3.9
dsengar121

Hi I'm Microsoft MCSA Certified professional with extensive PowerShell and scripting experience. Your requirement can be efficiently fulfilled using a PowerShell script. However, will require some clarification o More

£110 GBP in 1 day
(12 Reviews)
3.4
JVMHost

Hi, I am co-founder of [login to view URL] as well as their senior sysadmin. Data processing with Perl is one of my favourite tasks. I am eager to complete the task to your full satisfaction.

£29 GBP in 3 days
(1 Review)
2.2
AdrianCJ

I guess all of this can be done using batch as well but it would be much more easier (for me) to do it in powershell. Both csv and xlsx are natively supported so im pretty confident I can finish this

£150 GBP in 3 days
(4 Reviews)
1.8
mariushudea

Hello, Doing this would be quite difficult if not impossible, in Powershell. So I can't do it in Shell Script or Powershell, but I do have a lot of experience writing scripts in PHP. Basically, you would simply More

£50 GBP in 2 days
(0 Reviews)
0.0
valor312

Dear It's a pleasure to meet you. Can you show me an example of input .csv file and output .csv file? I have done many database related works using C#, Python, MySQL, MSSQL. and Excel, and VBA. Manipulating More

£50 GBP in 3 days
(0 Reviews)
0.0
pkushevski

Hello there, my name is Petar and i am a law student from Skopje, Macedonia, now few exams away from getting my Master's degree in Criminal law. To be honest here, now i have a spare time from college duties and i want More

£33 GBP in 1 day
(0 Reviews)
0.0
andyhaughton

I am a Microsoft consultant with many years working with Powershell for writing automation tasks. I can complete your project as per your exact requirements

£150 GBP in 3 days
(0 Reviews)
0.0
SPOThangu

Hi, This is something I can do, but I focus more on SharePoint and PowerShell. I just read your requirement inspite of busy schedule, since I made a video on automation which can help you [login to view URL] More

£277 GBP in 5 days
(0 Reviews)
0.0
maglite4cell

This task is not too difficult to do. When are you looking to have this completed? I have been working with powershell for over a year doing data manipulaton How many rows are you looking to process at one time? More

£83 GBP in 7 days
(0 Reviews)
0.0