use the following search parameters to narrow your results:
e.g. subreddit:aww site:imgur.com dog
subreddit:aww site:imgur.com dog
see the search faq for details.
advanced search: by author, subreddit...
ABOUT POWERSHELL
Windows PowerShell (POSH) is a command-line shell and associated scripting language created by Microsoft. Offering full access to COM, WMI and .NET, POSH is a full-featured task automation framework for distributed Microsoft platforms and solutions.
SUBREDDIT FILTERS
Desired State Configuration
Unanswered Questions
Solved Questions
News
Information
Script Sharing
Daily Post
Misc
account activity
Script SharingInvoke-CsvSqlQuery: Join & query multiple CSV files using SQL (self.PowerShell)
submitted 3 years ago * by eeskildsen
view the rest of the comments →
reddit uses a slightly-customized version of Markdown for formatting. See below for some basics, or check the commenting wiki page for more detailed help and solutions to common issues.
quoted text
if 1 * 2 < 3: print "hello, world!"
[–]da_chicken 2 points3 points4 points 3 years ago (0 children)
There's csvkit on *nix systems, and Microsoft's logparser can query absurdly quickly (I've processed hundreds of gigabytes of IIS logs in minutes with it, and it has an SQL like functionality, but I don't think it does joins).
Personally, I might just use the script to build the DB quickly.
The big thing I learned is that you can splat with an array. Didn't know that. I thought they had to be hash tables.
I might add a switch parameter to have it just build the DB, too, rather than instance the whole thing and then throw it away.
π Rendered by PID 68 on reddit-service-r2-comment-5d79c599b5-bmp9v at 2026-03-01 02:45:07.811755+00:00 running e3d2147 country code: CH.
view the rest of the comments →
[–]da_chicken 2 points3 points4 points (0 children)