Write a script

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

My project has 2 phases:

1) Code

2) Explain

1) I need a Windows PowerShell script developed that does two things:

1: Working with CSV files, it takes the filename and "date modified" meta-data from the windows system for each respective file and appends them as two additional columns in each given file (so each csv now contains a column with it's own file name and it's own date modified value which spans the length of rows in the CSV). CSV structure is row 1 = column headers; subsequent rows are comma separated data.

2: Upon completion of the first task, the script will then take all CSV in the folder and combine them into a single CSV file which contains a SINGLE column header. Column header IS consistent format between all CSV files so only the first row needs to be the column header, the rest is the data from every CSV in the folder dumped into the file.

The final intent is to import this whole file into a database table so I can do comparative audit work.

2) explain. Once it has been demonstrated this script works, I need the script explained to me so I am able to re-purpose it for future tasks. I am an SQL developer and can understand and follow logic and script flow, I am just not familiar with PS syntax and it will take me hours to bring myself up to speed, hence the job posting.

Powershell Scripting Shell Script

Project ID: #15468598

About the project

2 proposals Remote project Active 6 years ago

Awarded to:

stephenathompson

I have recently been working with PS and CSV files for another project. I was able to read from a CSV file to make changes to an Office365 environment. This task would be simple for me to complete. Relevant Skills and More

$25 USD in 1 day
(0 Reviews)
0.0

2 freelancers are bidding on average $35 for this job

pilica

Hi, I have experience in scripting with powershell, I can do this job. Please see my work history for relevant feedback. Relevant Skills and Experience powershell Proposed Milestones $45 USD - ini

$45 USD in 1 day
(16 Reviews)
3.9