Take the 2-minute tour ×
Server Fault is a question and answer site for professional 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|improve this 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
add comment

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|improve this answer
add comment

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|improve this answer
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
add comment

i suggest emeditor through wine

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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