On 31/01/2008 10:36, Thomas Calis wrote:
I'm using OO 2.3
My problem is:
I have imported my banking Statements of acount in OO Calc.
In the colums with the descriptions there is before all the sentences
a spacing.
How can I delete this spacing for al the cell's in a colums without
deleting a the other spacings? (I don't even know how to that)
1. Select the column.
2. Go to the "Edit>Find and Replace" menu option
3. Click the More Options button
4. Click in the little box labelled Regular Expressions
5. In the "Search for" box type the *three* characters "^ +" without the
quotes; that is Circumflex, Space, Plus.
6. Ensure that the "Replace with" box is completely empty - no spaces or
anything else.
7. Click Replace All
Done.
Read up about Regular Expressions in the Help and/or in any book about
Linux, Unix or Perl. The "pattern" "^ +" says "one or more spaces at the
beginning of a line (cell)". If you leave out the +, then you'll only
find cases where there is only one space at the beginning of the cell.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
