You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Nils Lundvang <lu...@bandofjules.com> on 2014/09/12 16:23:22 UTC
generic text in a column
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:
Kind regards
Nils Lundvang, CTO & Co-founder
Band of Jules
M: +45 20751233
Band of Jules ApS
Flæsketorvet 68
1711, Copenhagen V
lundvang@bandofjules.com
www.bandofjules.com
Re: generic text in a column
Posted by Brian Barker <b....@btinternet.com>.
At 16:23 12/09/2014 +0200, Nils Lundvang wrote:
>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:
Are we talking about a spreadsheet column or
perhaps a column of a table in a text document?
Suppose your existing text is in column A of a
spreadsheet, starting in cell A1.
o In row 1 of a suitable spare column, enter
="http://bandofjules.com/products/"&A1 ("&" is the concatenation operator).
o Fill this formula down its column as necessary.
o Select all the resulting values.
o Copy.
o Paste the results back over the original
column, but using Edit | Paste Special (or
right-click | Paste Special... or Ctrl+Shift+V)
instead of ordinary Paste. In the Paste Special
dialogue, remove the tick from "Paste all" if
necessary and ensure that Formulae is *not* ticked.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: generic text in a column
Posted by Julian Thomas <jt...@jt-mj.net>.
One way would be:
Save as csv
Use a text editor or a script to do the mods. Specifics depend on the layout of each row. Rex (regina) program to do this would be a snap.
Reload the modified csv
From my i5.
Julian Thomas http:jt-mj.net
In the beautiful Genesee Valley of Western NY State!
> On Sep 12, 2014, at 10:23, Nils Lundvang <lu...@bandofjules.com> wrote:
>
> 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:
> <PastedGraphic-2.png>
>
> Kind regards
>
> Nils Lundvang, CTO & Co-founder
> Band of Jules
> M: +45 20751233
>
> Band of Jules ApS
> Flæsketorvet 68
> 1711, Copenhagen V
> lundvang@bandofjules.com
> www.bandofjules.com
>
Re: generic text in a column
Posted by Regina Henschel <rb...@t-online.de>.
Hi Brian,
Brian Barker schrieb:
> Except I think you mean
> http://bandofjules.com/products/$1
yes.
>
> (or just
> http://bandofjules.com/products/&
> without the need for parentheses in the "Search for" field).
Indeed, that is nice, and documented in the help.
Kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: generic text in a column
Posted by Brian Barker <b....@btinternet.com>.
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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: generic text in a column
Posted by Regina Henschel <rb...@t-online.de>.
Hi Nils,
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/
> <http://bandofjules.com/products/willow-gold> 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".
Kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org