On Sun, Dec 21, 2008 at 01:02:59PM -0600, Robert Citek wrote: > Workaround:
Thanks Robert. I tested it on a sample sheet and it works well. I don't think it will be very efficient for this spreadsheet though. I failed to say that I've got multiple columns with empty cells scattered throughout, so I'm afraid multiple sorts will mess something up. There's so much data in this thing I just don't trust myself to not mess something up via multiple manipulations. But I've solved my problem -- only because I'm converting this spreadsheet into a MySQL file. This file describes photos in a database. For example, a few of my columns contain information like so: title publisher caption photographer I save the file as a CSV sheet. Then I run a very simple awk script that breaks the converted CSV "cells" into separate lines. Wherever there were empty cells, there are now blank lines and working in Vim it's easy to fill in those blank lines. This is my whole process. I'm sure others might find a more sufficient way to do this, but it works rather well: http://tinyurl.com/769j6h Sean -- Sun, 21 Dec 2008 14:10:51 -0600 --~--~---------~--~----~------------~-------~--~----~ Central West End Linux Users Group (via Google Groups) Main page: http://www.cwelug.org To post: [email protected] To subscribe: [email protected] To unsubscribe: [email protected] More options: http://groups.google.com/group/cwelug -~----------~----~----~----~------~----~------~--~---
