"jorge" == jorge <jrodriguez17@cpcecr.com> 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+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
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.