petes_bread_eqn_xls

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

❤️  

#emacs

Mar 24 at 9:06pmWeb
Show threadpetes_bread_eqn_xls3d ago

Lesson learned: org mode does NOT like big tables. A few dozen columns and a few hundred rows and it is painful.

#OrgMode

Show threadAnthony Cowley3d ago
@petes_bread_eqn_xls I want org tables to act as a preview of larger tables that I can easily jump into in their own buffer. So you get the first five and last three rows or something.
Show threadKemotep 🔰Mar 24

@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 threadpetes_bread_eqn_xlsMar 24
@kemotep I personally don’t know how to do that, but I don’t see why not
Show threadCharles Choi 최 민수Mar 24

@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...

Show threadéric 🚲 🇪🇺 Mar 25
@petes_bread_eqn_xls Excellent! It's so much easier to manipulate an org table than a spreadsheet, especially when it's all text.