That makes sense. I have been asked to write a program that does a standard spreadsheet function on multiple occasions, so I was just curious. Sometimes people just don’t know the tools at hand, want to offload their work, or think an over complicated workflow is a better workflow. I can see how it was actually useful in your case though.
I have an easier time doing that shit in powershell than I do in Excel which are the only tools I have available at work. I’m probably doing something wrong but I don’t do it often enough to remember what that is. My PS script just works.
How big were the CSVs? That sounds like a standard thing most spreadsheet apps can do already, unless the data size made traditional apps unusable.
The biggest ones I’ve seen are 1.2GB.
Why this company uses gigabyte CSVs is a separate problem.
(Also sometimes they want to compare a CSV to what’s in a database, which the script can also do but I didn’t mention in the post)
That makes sense. I have been asked to write a program that does a standard spreadsheet function on multiple occasions, so I was just curious. Sometimes people just don’t know the tools at hand, want to offload their work, or think an over complicated workflow is a better workflow. I can see how it was actually useful in your case though.
I have an easier time doing that shit in powershell than I do in Excel which are the only tools I have available at work. I’m probably doing something wrong but I don’t do it often enough to remember what that is. My PS script just works.