Re: [libreoffice-users] saving as csv newline inserted

It appears that the actual contents of Field2 = 05329954A\n where '\n' is a
RETURN (not a TAB).  I was able to remove the \n by (1) select/highlight
the column containing Field2, (2) open Data > Text to Columns, (3) Under
'Separator Options' set Y=Separated by, Y=Other as \n then click 'OK'.  Now
save as CSV.

On Wed, Jun 21, 2017 at 8:52 AM, Uwe Brauer <oub@mat.ucm.es> wrote:

> Hi
>
> I have an excel (xls) file which I open with scalc (5.3)
> and save it as csv
>
> Unfortunately it looks like
>
> Field1,Field2,Field3,Field4,Field5
> "Name","05329954A
>            ",0.55,0.75,1.3
>
> Instead of
>
> Field1,Field2,Field3,Field4,Field5
> "Name","05329954A ",0.55,0.75,1.3
>
>
> The reason is that in the first column there is a after name a space
> which is translated to a newline when exporting.
>
> How can I get rid of this unwanted newline?
> I tried to format the cells but it seemed not to have worked.
> Thanks
>
> Uwe Brauer
>
>
> --
> To unsubscribe e-mail to: users+unsubscribe@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

-- 
To unsubscribe e-mail to: users+unsubscribe@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