3
votes

I'm trying to find a command line editor (or vim plugin) for large CSV or TSV files that will fix the width of cells and keep the row and column headers in view so I can move between cells and edit data. Basically something like the old DOS versions of Lotus 123 or Quattro Pro.

I find myself continually doing quick fixes in tabular data and don't want to fire up Calc every single time I want to change a few cells in column 32. I am not looking for perl/awk solutions since most of the fixes are one-off spelling/case data entry errors.

closed as off-topic by HopelessN00b Mar 13 '15 at 17:47

This question appears to be off-topic. The users who voted to close gave this specific reason:

If this question can be reworded to fit the rules in the help center, please edit the question.

locked by HopelessN00b Mar 13 '15 at 17:48

This question exists because it has historical significance, but it is not considered a good, on-topic question for this site, so please do not use it as evidence that you can ask similar questions here. This question and its answers are frozen and cannot be changed. More info: help center.

Read more about locked posts here.

  • I don't know how to do the tab width fixing but ':1split' will give you a horizontal split window 1 line in size to keep the headers in view. Then Ctrl W-W will toggle you between the windows in VIM – davey Jul 14 '10 at 21:09
  • Just found macrocalc - looks interesting. – hurfdurf Jul 15 '10 at 0:25
  • @hurfdurf can you provide a link to the macrocalc you have found? – Jonas Stein Sep 22 '14 at 18:22
  • Here's the link to macrocalc: freakout.de/#download – hurfdurf Oct 10 '14 at 18:03
3
votes

Take a look onto sc or Gnu Oleo, the may fit your need's

Also a look onto the Emacs based Spreadsheets may be worth a look

cheerio Steve

2
votes

Sounds like you could use vim with ts/sw and friends to set up your columns widths, and then :1split to keep headers in view. You can also (assuming your CSV data doesn't have tabs in it already) do something like:

%s/,/\t/g

to switch commas to tabs, and

%s/\t/,/g

to switch them back, since it's easier to format TSV than CSV.

0
votes

i suggest emeditor through wine

Not the answer you're looking for? Browse other questions tagged or ask your own question.