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:
The Customer ID must be taken from "Input", looked up in the "lookup" sheet and the corresponding value written into the "Output" sheet.
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.
13 freelancers are bidding on average £93 for this job
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.
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
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