Another small project for work in which the department requests to take a weekly export of data in the form of a CSV, or more accurately a list of semi-colon separated values (ssv?) and append certain data depending on the year found within each row.

Another fun quick project written using javascript/jQuery that utilizes the FileReader() class in jQuery and the onchange event in javascript on the <input type=”file”> element to load that file into a new instance of FileReader object and begin an asynchronous process that loads the lines into an array. From there the array is copied over and the relevant keywords/data are appended to the end of each array element according to predefined criteria.

This code is executed and creates the new payload client-side.

Script Here