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

[Uwe Brauer]

>>> "jorge" == jorge   writes:

   > Hi Uwe and all:
   >I suggest:

   > a) Open the file as is: csv
   > b) Mark the column that content all the information
   > c) Use: Menu, Edit, Search and Replace ... click there
   > d) In the window opened: In the first row for input what to search,
   > input and "space" with spacebar
   > e) In the second row for input what to replace, keep without input
   > f) Apply the option Replace All
   > g) Now if all is good, you are eliminate the space after "name" field
   > h) Save the file again as csv
   > i) Now you can close the file and open again or use the option: Menu,
   > Data, Text to Column to split the fields in the column

Thanks, I did it with replace regexp using \n which also worked nicely.
I will keep in mind you suggestion for other cases, thanks
   > I hope this help,


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

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

[Uwe Brauer]

>>> "Bruce" == Bruce Hohl  writes:

   > 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.

Thanks, that works nicely. I don't know how the heck the \n entered, but
at least I know how to deal with it. thanks


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