Mastodawn

petes_bread_eqn_xls Mar 24

insert a CSV into a buffer, convert it to an org table, transpose it, add a meaningful header line, export back to CSV

just a few keystrokes to accomplish all that

❤️

@petes_bread_eqn_xls hmmm. Maybe I need to learn emacs.

I guess with Lisp too you could programmatically convert that csv into SQL and back too?

Show thread

Charles Choi 최 민수

@kemotep @petes_bread_eqn_xls Once you’ve converted CSV to an Org table, you can run in-memory SQL queries on it.

http://yummymelon.com/devnull/running-sql-queries-on-org-tables.html

Running SQL Queries on Org Tables

One of the best things in Org Mode are tables and if you know SQL, you have at your disposal the ability to process your tables like a SQL database. Even better, you can run a SQL query on...