On Fri, 19 Aug 2011 14:17:47 -0700, NoOp <[email protected]> wrote:
>On 08/17/2011 08:44 PM, [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! >> > >If you can get it into Writer, the Alternative Find & Replace Extension >might be a good choice: > >http://www.volny.cz/macrojtb/AltSearch_cs.html >http://www.volny.cz/macrojtb/AltSearchScr_en.html >[screenshots] Actually, I do know how to get the appropriate cells into a Writer table. What I don't know is how to get them back into the spreadsheet after they've been manipulated there. :-) -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
