What I'm needing to do is fairly simple (on paper), however, script wise I'm not sure. I receive a .ZIP file everyday in my Lotus Notes Inbox. This .ZIP file is nothing more than a .CSV report. What I'd like the script to do is open the ZIP attachment from within My Lotus email. The subject line for this report I receive is always the same, so perhaps we could filter on that so it knows exactly what emails to act on.
Once the script is able to extract the .CSV from the ZIP, I'd like to then remove ALL COLUMNS in that .CSV file, but the following:
1.) Event TimeStamp (UTC)
2.) Network Node Address
3.) Target User
4.) Source Computer
It would drop the newly formatted .CSV file on my desktop. Finally, it would then do a "Sort By A to Z" function on column "Target User"
The end result output would look like this: