2011/8/18 Mike Scott <[email protected]>: > 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.
Or you could simply use sed in a terminal. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
