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
What’s new in version 1.8.3
Updated on Mar 01 2021
Version 1.8.3:
General improvements:
Register as a handler for all supported database schemes (postgres://, postgresql://, mysql://, mariadb://, redis://), so you can click on a database link and get a new Strukt pipeline for it
Change name of default document from "Untitled" to "Pipeline", as suggested by Apple's documentation
For URL parameters missing both scheme and host, only display one error message
Internal improvements, as always, to deal with changing developer tools
Bugs fixed:
Fix possible crash in conversion from NSNumber when using legacy parsers (JSON, plist, EXIF data)
Fix possible crash in logging sidebar when copying with the context menu
Operations:
Extend "Filter By Position" to allow omitting the high end of ranges, like "10-"
Add "bonjour" and "rendezvous" as aliases for "List Zeroconf Services"
In "Generate JSON", for NaN or Inf, log a warning, and use a string instead. (JSON doesn't allow NaN/Inf.)
Does Strukt help in this regard - below?
Not sure how to contact developer.
I am looking for an App to parse large text files (>5 million records at a time).
These define fields by the number of characters from the beginning of the string.
There may be 100 fields per record.
The parsing rules may change from month to month, so there needs to be flexibility.
So the ability to store and retrieve an array of parsing rules is important.
I don't have time to learn GAWK ...