On Sat, 22 Dec 2012, Tom Davies wrote:
My ham-fisted kludge would probably be to save the Csv and then open it in a text-editor, such as Kate, Gedit, Notepad or whatever and then do search&replace to look for
Tom, I use emacs for almost all my writing.
, , and replace with , " ",
The problem with searching for ,, and replacing them with ,'', is that blank number cells are also quoted. SQL does not like that. :-)
Perhaps in Calc add an unusual combination of characters in thse empty cells.
The first thing I did was save the freshly-opened .csv as .ods. I get client data as exports from their Excel spreadsheets (sigh) which I save as .ods, then clean up. When I save the .ods file as .csv the text fields -- even the blank ones -- are quoted. That's not working with these files. I'm trying (with C-h) to replace all blank cells with NA. However, with 105000 rows and about 50 columns it takes a very long time ... I gave up for today. But, I'll try again tomorrow. Then I can block number columns and replace the NA with blanks. Quite the hassle, Rich -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
