Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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.

share

locked by HopelessN00b Mar 13 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.

closed as off-topic by HopelessN00b Mar 13 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.

    
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 Answers 3

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

share

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.

share
2  
+1 You can do anything in Vim ;-). –  sleske Jul 15 '10 at 21:29
2  
@sleske, anything? Then why do we fill our machines with thousands of different programs for different purposes. If I've said it once I've said it a billion times - don't exaggerate. –  John Gardeniers Jul 15 '10 at 21:41
1  
As far as I know, cs.cmu.edu/afs/cs/project/ai-repository/ai/areas/classics/eliza/… has never been put into vim. But otherwise, yep! –  BMDan Jul 15 '10 at 21:42
    
vim.org/scripts/script.php?script_id=294 (Align) looks like it could be useful as well. –  hurfdurf Jul 16 '10 at 0:13

i suggest emeditor through wine

share

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