structured-text-tools
tsv-utils
Our great sponsors
structured-text-tools | tsv-utils | |
---|---|---|
13 | 10 | |
6,865 | 1,396 | |
- | 0.6% | |
8.1 | 0.0 | |
24 days ago | over 1 year ago | |
D | ||
- | Boost Software License 1.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
structured-text-tools
- Command line tools for manipulating structured text data
-
creating a text file in Linux
This works well in scripts and logs of all the commands you need to do to reproduce the current state of the system from a scratch install. Also can be used with diff -u and patch, sed, perl, and awk oneliners and structured text tools. You can also capture most of the commands using sudo logging feature but it won't capture the here documents. But for modest size files you can use newlines in echo commands. Note that commands which use redrection should use something like ~~~~ sudo bash -c "echo 'foo' >>file.txt" ~~~~ instead of "sudo echo foo >>file.txt" or "echo foo | sudo tee -a file.txt
-
Using Commandline to Process CSV Files
TFA is about how to handle csv files with awk. This might be useful in straightforward cases.
For all others I’d recommend to have a look at
https://github.com/dbohdan/structured-text-tools
which lists tools to handle structure text formats
-
Combine multiple files
in general, I'd pick something from https://github.com/dbohdan/structured-text-tools
- Show HN: Xq – command-line XML and HTML beautifier and content extractor
- structured-text-tools: A list of command line tools for manipulating structured text data
- A list of command line tools for manipulating structured text data
-
What is your favourite Linux backup software and why?
Also, here is a list of structured text tools. You may find some tools there that are helpful in editing configuration files from the command line. Or you can use "diff -u" to create a patch file (you need to save the patch files along with sudo.log) to recreate. Also, use sfdisk --dump and sfdisk --backup to save partition information in a form that can be used to recreate backups.
tsv-utils
-
Frawk: An efficient Awk-like programming language. (2021)
If you need just csv/tsv parsing, you can also take a look at https://github.com/eBay/tsv-utils
-
Tracking SQLite Database Changes in Git
You might want to look at tsv-utils, or a similar project: https://github.com/eBay/tsv-utils
For the SQL part, but maybe a lot heavier, you can use one of the projects listed on this page: https://github.com/multiprocessio/dsq (No longer maintained, but has links to lots of other projects)
-
I feel like an idiot but… I need Excel help.
TSV is most often a better format than CSV. Localization, in particular, is a nightmare with CSV.
- Splitting CSV files at 3GB/s
-
Modernizing AWK, a 45-year old language, by adding CSV support
For anything down and dirty, what's wrong with -F'"'? For anything fancy there are plenty of things like the below.
eBay's TSV Utilities: Command line tools for large, tabular data files. Filtering, statistics, sampling, joins and more.
includes csv to tsv: https://github.com/eBay/tsv-utils
HT: https://simonwillison.net/
-
Dlang 2.098.0 released, now available on OpenBSD
As an example, eBay's tsv-utils took full advantage of the GC and performed better than existing programs that had been hand-optimized in C etc.
-
[OC]Tidy Viewer (tv) is a cross-platform csv pretty printer that uses column styling to maximize viewer enjoyment.
tsv-utils - Command line csv data manipulation toolkit. D
-
Changing Registry Key Value Based on Contents of TXT/CSV File
In the majority of cases you'll be better off with Tab Separated Values over Comma Separated Values. More info here.
-
Return 1 to N results from a large (19MM line) CSV
May well be overkill for your needs, but I'm a fan of tsv-utils It's fast and enormously flexible, and seems to me a "best of breed" toolset for data mining CSV files (that is what it was written for). https://github.com/eBay/tsv-utils
What are some alternatives?
yq - yq is a portable command-line YAML, JSON, XML, CSV, TOML and properties processor
dextool - Suite of C/C++ tooling built on LLVM/Clang
python-benedict - :blue_book: dict subclass with keylist/keypath support, built-in I/O operations (base64, csv, html, ini, json, pickle, plist, query-string, toml, xls, xml, yaml), s3 support and many utilities.
csvtk - A cross-platform, efficient and practical CSV/TSV toolkit in Golang
concise-encoding - The secure data format for a modern world
q - Quick and dirty debugging output for tired programmers. ⛺
datasette - An open source multi-tool for exploring and publishing data
goawk - A POSIX-compliant AWK interpreter written in Go, with CSV support
awesome-cli-apps - 🖥 📊 🕹 🛠A curated list of command line apps
zsv - zsv+lib: world's fastest (simd) CSV parser, bare metal or wasm, with an extensible CLI for SQL querying, format conversion and more
miller - Miller is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSON
xsv - A fast CSV command line toolkit written in Rust.