this post was submitted on 11 Jul 2024
55 points (95.1% liked)
Linux
47991 readers
1043 users here now
From Wikipedia, the free encyclopedia
Linux is a family of open source Unix-like operating systems based on the Linux kernel, an operating system kernel first released on September 17, 1991 by Linus Torvalds. Linux is typically packaged in a Linux distribution (or distro for short).
Distributions include the Linux kernel and supporting system software and libraries, many of which are provided by the GNU Project. Many Linux distributions use the word "Linux" in their name, but the Free Software Foundation uses the name GNU/Linux to emphasize the importance of GNU software, causing some controversy.
Rules
- Posts must be relevant to operating systems running the Linux kernel. GNU/Linux or otherwise.
- No misinformation
- No NSFW content
- No hate speech, bigotry, etc
Related Communities
Community icon by Alpár-Etele Méder, licensed under CC BY 3.0
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Amazing post! I’ve been wanting to do the same… Have you found a CLI .csv file editor? One of the points of friction for me is finding how to replace Excel’s functionality past Libreoffice. I’m more curious to see what that workflow can do when one uses no GUI whatsoever.
VisiData may do what you want.
If you want to mess around with scripting instead of an editor I would recommend Awk- it works great for CSV files and is really powerful. Usually you can use
-F,
to separate using commas, but for full CSV support (with potential quoted commas) you need to use something like-vFPAT='[^,]*|"[^"]*"'
(which isn't POSIX compliant but works with gawk)csv-mode on emacs
I've found sc-im to be very useful, but I'm still a little new to it. Visidata is another one that seems to be a lot more powerful than sc-im.
I have used sc-im a few times, I like the simplicity and vim shortcuts.
Thanks for mentioning visidata, I'll install it.