Re: [libreoffice-users] Calc: Text Columns Not Quoted When Saving .csv

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: users+help@global.libreoffice.org
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