This may be a little long and I apologize for that, particularly since it is my first post here.
I have a couple projects going on at work that are going to involve taking .csv files that are exported from another application and analyzing the data therein. These .csv files contain quite a bit of data and will contain anywhere from about 4,000 - 6,000 lines in the spreadsheet.
I cant post a snippet of the spreadsheet as the company I work for would frown upon that, LOL. However, basically the file will contain data about programs and scripts that run, their start time and end time among other data. I have one .csv export that deals with when the programs fail and one that deals when they run and complete successfully. The export that deals with failures I wrote a VBA script that filters the data down and organizes it so that we can look at 30-day periods. It works well but I am not the best VBA coder around as I just started learning this year. What I have works but I want to do more and in a better fashion and analyze over a longer period of time.
Whew! Okay, so all that to ask what would be the best coding language(s) to learn in order to take these .csv exports, filter out the data we don't need, put whats left in a database, display that data as a HTML table and be able to run various analysis on that data? For example, since one of the data points I am interested in involves the start and stop times, I would like to be able to calculate the actual time it took to complete but also store that result and then be able to calculate the average completion time so that later I can check whether or not a particular execution time is taking longer than normal.
At any rate, as I said, it may be a long post. At this point I am just looking for the best coding language to do all this. I don't mind learning, I enjoy it but I don't necessarily want to learn and be familiar with a particular language only to find out that its not going to be able to do what I want well or was not the best route. So I thought would subject you all to this enormously long post to get your input. On top of that, hopefully I placed this in the correct are.
Thanks in advance for taking the time to read this and for any help and insight you may be able to provide.