Strukt

Strukt allows you to process or analyze any tabular data you have, any way you want, and see the results right away. No need to load it into a database. Just put some operations together, and see the result right away.

Features

• Pull data from files, folder listings, URLs, the clipboard, Git repositories, and more
• Parse CSV, TSV, XLSX, JSON, log files, SQLite, and others
• View as a table, a 2D chart, plain text, HTML, or a map
• Use real data types: strings, numbers, booleans, dates, locations, colors, blobs, nulls
• Updates in real time, as you edit the pipeline steps
• Keyboard-friendly
• Actual online user manual

Performance improvements:

• "Rename Key" and "Compute" take less memory
• "Count Rows" uses a much faster word-count API

Operation improvements:

• For all JS operations, exceptions are logged in the sidebar
• For all JS operations that take input cards, there's a new "var" flag, which lets you request the entire card be assigned (as a dictionary) to a usable var. This can be handy if your keys aren't valid JS identifiers.
• In "Filter by Expression", an exception counts as "not a match" (but still obeys the "invert?" flag)
• "Remove Blank Lines" has a new "invert?" flag
• "Compute" now has "function" as an alias

Output view improvements:

• Filter/Parse context menus now match order of data types used in the manual
• New table header submenus "Analyze" and "Filter by Value" (hold option to invert, as always)
• For text view, there's a new monospaced option

Bug fixes:

• Fixed possible crash in "Filter by Filename"
• For JS identifiers, allow characters "$" and "_", and not just in the first position

Miscellaneous:

• New documentation section for DSLs (regexes, globs, JavaScript)