Managers
you are viewing a single comment's thread
view the rest of the comments
[–] 14 points 5 months ago (3 children)

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.

  • source
  • parent
  • hideshow 3 child comments
  • [–] 23 points 5 months ago (1 child)

    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)

  • source
  • parent
  • hideshow 1 child comment
  • [–] 8 points 5 months ago

    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.

  • source
  • parent
  • [–] 4 points 5 months ago

    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.

  • source
  • parent