On 18/08/2011 04:44, [email protected] wrote:
On Tue, 16 Aug 2011 22:30:38 -0500, [email protected] 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 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?
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 [email protected]
For additional commands send email to [email protected]
with Subject: help
