Let's see how many #AdventOfCode challenges can we solve using SpectX' log parser and query engine.
Tasks: https://adventofcode.com
Free SpectX: www.spectx.com/get-spectx
The queries run on test data or @iiton's input. Replace the path in the LIST row to try these on your own data.
For example:
LIST('https://raw.githubusercontent.com/spectx/aoc2020/main/day1/input/input.txt')
->
LIST('file:/Users/john/Downloads/input.txt')Documentation: https://docs.spectx.com
Example queries for log formats like apache, AWS CloudFront, Microsoft IIS, Google Suite, Office 365, OpenVPN, PowerShell transcripts, etc. https://github.com/spectx/query_pack