At 18:33 12/09/2014 +0200, Regina Henschel wrote:
Nils Lundvang schrieb:
I have a column with different texts (handles
of products)
I would like to insert the
following in front of the existing text of all
the cells..all the way down. How is this done?
the following text is what is to be inserted.
See the attached file for the column with the
cells that need the text in front of it.
http://bandofjules.com/products/ should be in front of all these:
and here a solution with regular expression:
Mark all those cells
Open Find&Replace dialog
click on More options
mark "Regular expressions" and "Current selection only"
In Find field write
(.+)
in Replace field write
<http://bandofjules.com/products/willow-gold>$1
Replace All
Explanation:
.+ means at least one character, character is arbitrary
the brackets establish a reference
$1 uses this reference to keep the old content
As always with Find&replace, make a backup or at
least save before using "Replace All".
This is much better than my solution, of course.
I've given myself a black mark!
Except I think you mean
http://bandofjules.com/products/$1
(or just
http://bandofjules.com/products/&;
without the need for parentheses in the "Search for" field).
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
