[users] Re: RegEx to Add HTML Codes to CSV
On 18/08/2011 04:44, tambl...@gmail.com wrote: On Tue, 16 Aug 2011 22:30:38 -0500, tambl...@gmail.com wrote: Can someone help me figure out the find and replace for this? I've imported a CSV into a spreadsheet (migrating a site from Wordpress to Joomla). The field for the posts has newline characters, which won't be automatically converted to paragraph HTML tags by Joomla as they were in Wordpress. So, basically, I need to put ap tag at the beginning of each paragraph, and a/p tag at the end of each paragraph. I thought this would be easy, and found the regex info in the help file, but every time I try to run it, I'm told that the beginning or end of the paragraph isn't found. It's not finding \n, either. I do have the Regular Expressions and Current Selection Only boxes checked. Is it looking for Writer paragraphs? Is there something else I should be searching for in Calc? I can always edit each post to add these tags if I have to. There are only 500 or so of them, but I'd really like to avoid that. :-) I've since found out that the problems with this are due to the limitations of find/replace in Calc. Does anyone know how to work around it? Thanks! Not an OOo solution, but I find perl is good for this sort of thing. You could preprocess your csv before importing into Calc. -- Mike Scott Harlow, Essex, England -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: RegEx to Add HTML Codes to CSV
2011/8/18 Mike Scott m...@scottsonline.org.uk: On 18/08/2011 04:44, tambl...@gmail.com wrote: On Tue, 16 Aug 2011 22:30:38 -0500, tambl...@gmail.com wrote: Can someone help me figure out the find and replace for this? I've imported a CSV into a spreadsheet (migrating a site from Wordpress to Joomla). The field for the posts has newline characters, which won't be automatically converted to paragraph HTML tags by Joomla as they were in Wordpress. So, basically, I need to put ap tag at the beginning of each paragraph, and a/p tag at the end of each paragraph. I thought this would be easy, and found the regex info in the help file, but every time I try to run it, I'm told that the beginning or end of the paragraph isn't found. It's not finding \n, either. I do have the Regular Expressions and Current Selection Only boxes checked. Is it looking for Writer paragraphs? Is there something else I should be searching for in Calc? I can always edit each post to add these tags if I have to. There are only 500 or so of them, but I'd really like to avoid that. :-) I've since found out that the problems with this are due to the limitations of find/replace in Calc. Does anyone know how to work around it? Thanks! Not an OOo solution, but I find perl is good for this sort of thing. You could preprocess your csv before importing into Calc. Or you could simply use sed in a terminal. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: RegEx to Add HTML Codes to CSV
On 18/08/11 09:48, Johnny Rosenberg wrote: So, basically, I need to put aptag at the beginning of each paragraph, and a/ptag at the end of each paragraph. I thought this would be easy, and found the regex info in the help file, but every time I try to run it, I'm told that the beginning or end of the paragraph isn't found. It's not finding \n, either. I do have the Regular Expressions and Current Selection Only boxes checked. Is it looking for Writer paragraphs? Is there something else I should be searching for in Calc? ... Not an OOo solution, but I find perl is good for this sort of thing. You could preprocess your csv before importing into Calc. Or you could simply use sed in a terminal. True, not that that comes as standard with windows. He doesn't say what OS he's using. (Besides, I've never really got my head round sed :-) Given perl's portability and its flexibility in pattern matching, it's my own tool of choice for anything from one-off one-liners to OS maintenance scripts to well, whatever.) -- Mike Scott Harlow, Essex, England -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users]
Efter installation av OpenOffice.org 3.3 och klick på ikonen-genvägen får jag till svar att Det går inte att starta programmet - - - Berkeley Db error (0): Db open: File exists. Varför blir det så? Använder en Fujitsu Siemens Amilo La 1703 med Windows Vista Home Basic 32-bitars operativsystem. M.v.h. o.s.a., tack! Mats-G. Svennung Åsenvägen 9 SE-790 15 Sundborn (+46 (0)23 602 10-- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re:
Den 13 augusti 2011 15:41 skrev Mats-G. Svennung svennung@falubo.se: ** Efter installation av OpenOffice.org 3.3 och klick på ikonen-genvägen får jag till svar att Det går inte att starta programmet - - - Berkeley Db error (0): Db open: File exists. Varför blir det så? Använder en Fujitsu Siemens Amilo La 1703 med Windows Vista Home Basic 32-bitars operativsystem. M.v.h. o.s.a., tack! Mats-G. Svennung Åsenvägen 9 SE-790 15 Sundborn (+46 (0)23 602 10 Hej Mats ! Kanske denna länk ( http://user.services.openoffice.org/en/forum/viewtopic.php?f=6t=37810) kan hjälpa Dig att lösa problemet ?... Henri * * -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: RegEx to Add HTML Codes to CSV
2011/8/18 Mike Scott m...@scottsonline.org.uk: On 18/08/11 09:48, Johnny Rosenberg wrote: So, basically, I need to put ap tag at the beginning of each paragraph, and a/p tag at the end of each paragraph. I thought this would be easy, and found the regex info in the help file, but every time I try to run it, I'm told that the beginning or end of the paragraph isn't found. It's not finding \n, either. I do have the Regular Expressions and Current Selection Only boxes checked. Is it looking for Writer paragraphs? Is there something else I should be searching for in Calc? ... Not an OOo solution, but I find perl is good for this sort of thing. You could preprocess your csv before importing into Calc. Or you could simply use sed in a terminal. True, not that that comes as standard with windows. He doesn't say what OS he's using. (Besides, I've never really got my head round sed :-) Given perl's portability and its flexibility in pattern matching, it's my own tool of choice for anything from one-off one-liners to OS maintenance scripts to well, whatever.) Well, I'm so tired of asking people what operating system they are running, so I just give the answers that I would like myself if I asked the same question. If the operating system is not mentioned I assume that he or she has the same operating system as me. So why I suggested sed is that it's pre-installed if your operating system is the same as what I've got, and he didn't say otherwise in his original post. Even if he runs Windows, maybe someone else having the same problem can find the solution in sed, who knows? By the way, sed can be installed in windows, at least 32-bit: http://gnuwin32.sourceforge.net/packages/sed.htm But I haven't tried it myself since I don't have Windows. On the other hand, if you are going to install sed, you could rather install Perl instead… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: RegEx to Add HTML Codes to CSV
2011/8/18 Mike Scott m...@scottsonline.org.uk: On 18/08/11 09:48, Johnny Rosenberg wrote: So, basically, I need to put a p tag at the beginning of each paragraph, and a /p tag at the end of each paragraph. I thought this would be easy, and found the regex info in the help file, but every time I try to run it, I'm told that the beginning or end of the paragraph isn't found. It's not finding \n, either. I do have the Regular Expressions and Current Selection Only boxes checked. Is it looking for Writer paragraphs? Is there something else I should be searching for in Calc? ... Not an OOo solution, but I find perl is good for this sort of thing. You could preprocess your csv before importing into Calc. Or you could simply use sed in a terminal. True, not that that comes as standard with windows. He doesn't say what OS he's using. (Besides, I've never really got my head round sed Given perl's portability and its flexibility in pattern matching, it's my own tool of choice for anything from one-off one-liners to OS maintenance scripts to well, whatever.) Well, I'm so tired of asking people what operating system they are running, so I just give the answers that I would like myself if I asked the same question. If the operating system is not mentioned I assume that he or she has the same operating system as me. So why I suggested sed is that it's pre-installed if your operating system is the same as what I've got, and he didn't say otherwise in his original post. Even if he runs Windows, maybe someone else having the same problem can find the solution in sed, who knows? By the way, sed can be installed in windows, at least 32-bit: http://gnuwin32.sourceforge.net/packages/sed.htm As a Windows user, I'm kind of partial to Notepad++ as a general purpose text/hacking editor. It has regular expression search, so in theory at least you should be able to open your csv file and process it within the editor. http://notepad-plus-plus.org/ -mike brady -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Hyperlinks in docs
On my Mac, I've found that I usually have to select the link text first (just left-click on it) and then Command-click to actually jump to the link. On 8/18/11 users-requ...@openoffice.org wrote: Subject: [users] Re: Hyperlinks in docs From: Guy Voets nimant...@gmail.com Date: Tue, 16 Aug 2011 10:46:42 +0200 To: users@openoffice.org 2011/8/15 Robert Peirce b...@peirce-family.com: Since my version of Word won't work in Apple OS 10.7, I am converting my doc files to odt. I opened a file that has hyper-links and it said to command click the link, which I did, but it didn't take me there. Does something need to be changed to get these to work in OpenOffice? I am running 3.3.0. Hello Robert, Yes, to activate a hyperlink on Macs, you use Command-click (next to space bar) in LibO and OOo. It works for me... Maybe take a look at menu EditHyperlink? -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Hyperlinks in docs
Hi Michael:
This is no surprise. On a PC or in Linux, one would use {ctrl-click} to
do the same, yet for a .PDF generated with the same hyperlinks embedded,
one would merely click.
Howqever I also find often enough that in my Calc workbooks (.ODS
format), the hyperlinks on my summary sheet will jump nicely to the tens
of other sheets without the need for the {ctrl-click}.
It may be that the authors of Writer wanted to leave a simple click open
to other uses, I'm not sure.
Best regards from Canada,
Bruce Martin.
On 8/18/2011 22:36, Michael Reich wrote:
On my Mac, I've found that I usually have to select the link text
first (just left-click on it) and then Command-click to actually jump
to the link.
On 8/18/11 users-requ...@openoffice.org wrote:
Subject:
[users] Re: Hyperlinks in docs
From:
Guy Voets nimant...@gmail.com
Date:
Tue, 16 Aug 2011 10:46:42 +0200
To:
users@openoffice.org
2011/8/15 Robert Peirce b...@peirce-family.com:
Since my version of Word won't work in Apple OS 10.7, I am
converting my
doc files to odt. I opened a file that has hyper-links and it
said to
command click the link, which I did, but it didn't take me there.
Does
something need to be changed to get these to work in OpenOffice?
I am
running 3.3.0.
Hello Robert,
Yes, to activate a hyperlink on Macs, you use Command-click (next to
space bar) in LibO and OOo.
It works for me...
Maybe take a look at menu EditHyperlink?
--
Best Regards, Bruce Martin
--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help
[users] Re: Hyperlinks in docs
Bruce_Martin wrote:
Hi Michael:
This is no surprise. On a PC or in Linux, one would use {ctrl-click} to
do the same, yet for a .PDF generated with the same hyperlinks embedded,
one would merely click.
Howqever I also find often enough that in my Calc workbooks (.ODS
format), the hyperlinks on my summary sheet will jump nicely to the tens
of other sheets without the need for the {ctrl-click}.
It may be that the authors of Writer wanted to leave a simple click open
to other uses, I'm not sure.
Best regards from Canada,
Bruce Martin.
There is a setting under Tools Options OpenOffice.org Security under
the Options button that allows you to change to just click on
hyperlinks. But it is hard to edit a document when you not click to put
the cursor where it is needed, in the middle of that hyperlink.
Andy
--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help
