El 18/02/15 a las 12:56, Brian Barker escribió:
At 08:51 18/02/2015 -0500, Manuel Andres Ramirez wrote:
El 17/02/15 a las 10:06, Brian Barker escribió:
At 09:19 17/02/2015 -0500, Manuel Andres Ramirez wrote:
El 17/02/15 a las 06:00, Uwe Brauer escribió:
I periodically receive excel files (generated by Office 2010 I
think, but saved in the old binary format). Some of these columns
cause me problems, since they seem to contain spaces and even
newlines. I could correct that manually, but since the file
contains hundred of lines this is cumbersome. So the question is
whether there exist any formatting function which could resolve
the issue.
You can use TRIM() or LIMPIAR() "in spanish" function over the
column C and correct the spaces or tabs.
I tried TRIM(), but this seemed to do nothing in this case. It would
not remove the tabs or line breaks or non-breaking spaces; it could
remove the ordinary spaces, but only when they were trailing - so
only if the non-breaking spaces had already been removed.
Sorry, I tested with libreoffice in spanish and use LIMPIAR()
function, so I translated wrongly as TRIM(), but now I realize that
the correct function is CLEAN()
Aha! You can see that my Spanish is non-existent!
Try with CLEAN() over the Uwe attachment.
In fact I had already tried using CLEAN() without success. I found
that CLEAN() would remove the line break but only two tab characters
at a time, so something like
=CLEAN(CLEAN(CLEAN(C1)))
was necessary even to remove all five tab characters. But that still
left the space and the final non-breaking space. Applying TRIM() did
not remove those, nor would VALUE() ignore them, so that transpired to
be a dead end.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
Yes, you're right.
Maybe, as Andrew sugested in the list , the search and replace could be
the solution.
Try this.
First, select the column C
Call the search and replace option in the edit menu.
In Search box fill with \n\t\t\t\t\t..
In Replace box left empty
Click to open the more options
mark option "Only in current selection" (I'm using a spanish versión, so
I don't remember the correct words in english)
mark oprtion "Regular expression"
Click Replace all
The pattern "\n\t\t\t\t\t.." correspond to the weird caracters in cells
of column C, if this pattern change, maybe this solution need a fix.
Try it, and we'll see.
--
Manuel Andrés Ramírez P.
Administrador Informático
GNU/Linux Registered User:412887
Visite:www.getgnulinux.org/es/
<<Yo Tengo mi Office Legal y no pagué por su licencia>>
"El placer más noble es el júbilo de comprender"
(Leonardo Da Vinci)
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
