qsv pro (preview) v0.5.0
✨ What's new in v0.5.0? Click here to find out! 🔍
This update has many changes. Here are a few highlights (see below for more details):
- Upgraded qsv to v0.128.0
- New search feature - search records for matches using regex
- SQL query feature updates
- Save search matches output and SQL query output to a file with multiple available file formats (CSV, TSV, TAB, JSON, JSONL, Parquet, Arrow, Avro, etc.)
- Configurator update - copy a full command to clipboard with a simple Copy command button
New search feature
- Search your entire spreadsheet for matches (powered by
qsv search
) - Search by all columns or a specific column
- Toggle case sensitivity
- Matched rows are highlighted and occasionally matched text within rows are also highlighted
- Skip forward and backward to pages that have matches
- Save matches to a file with multiple available file formats (CSV, TSV, TAB, JSON, JSONL, Parquet, Arrow, Avro, etc.) with error handling
- Cancel an ongoing search with the Cancel button
- Experimental Autosearch feature (enable in settings) with customizable delay time
Data table interactive cell expansion/truncation & vertical borders
- Click on a truncated cell to expand its contents and click again to truncate again. You can also perform this action on the frequency headers.
- Added a switch to toggle vertical column borders for all data tables.
SQL query export to file & cancel button
- Save output to a file with multiple available file formats (CSV, TSV, TAB, JSON, JSONL, Parquet, Arrow, Avro, etc.) with error handling
- Cancel an ongoing SQL query with the Cancel button
Configurator copy to clipboard & updates
- Automatically display qsv subcommand, arguments, and options as part of a command
- Copy full command to clipboard with a simple "Copy command" button (e.g., paste it into your terminal to use it with qsv directly if you have qsv already installed)
- Display estimated elapsed time for command run
Other changes
- Workflow header hidden when a file is imported
- Data table card hidden when a file is imported, moved Choose file button beside CKAN upload button
- Add step to generate index file after screening and before pre-analysis
- Clarify durations and timestamps may be estimates for action logs.
- Estimated total processing time displayed beside file path
- Updated action logs, including additional logs when a search or SQL query is performed
- Displaying informational toast about how to scroll a data table horizontally by holding shift while scrolling
- Added note for
qsv sniff
potentially displaying incorrect output - Fix
--limit
option forqsv frequency
in Configurator - Modify stroke size for theme switch icon
- Update width for data table pagination arrows
- Mention frequency and decimal values may be estimations regardless of wrap rows toggle status
- Attempt to display "Purchase license key" in context menu only when user is on a trial
- Fix Configurator output by removing empty new lines
- Metadata subtabs switch to Basic when
qsv sniff
metadata is not available
👋 About qsv pro
Based on the qsv CLI toolkit, qsv pro is a data wrangling desktop app to interact between qsv and your spreadsheet files.
Want to learn about what qsv pro has to offer? Check out our promo website at qsvpro.dathere.com!
⬇ Download qsv pro (preview) v0.5.0 ⬇
Important note for Windows users (click here)
If you get a message about Windows protecting your PC like above, then you'll need to click More info then Run anyway as we currently don't have a certificate assigned to our Windows binaries.
- Windows
- macOS
- Linux
The .msi
, .exe
, .app
, and .AppImage
files are set up for automatically receiving the latest release's updates when you start up qsv pro.
By using qsv pro you agree to datHere's Terms and Conditions and Privacy Policy.