And if Ariel's excellent answer isn't complete enough, there is always the wiki:
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Regular_Expressions_in_Writer Some of this stuff may be version dependent? M On Thu, Sep 8, 2011 at 5:54 PM, Ariel Constenla-Haile < [email protected]> wrote: > Hello Mark, > > On Thu, Sep 08, 2011 at 11:25:12AM -0400, Mark Saul wrote: > > I'm a new user of Open Office. Can anyone help me with two tasks? > > Both are related to importing data into a word processing document. > > > > 1) Often, text comes in with a 'carriage return' (paragraph sign) at > > the end of each line, which you have to get rid of. Can I do this > > with search-and-replace? > > > > In MS-Word, you just searched for '^p' and got all the paragraph > > signs, which you could delete, replace, etc. But I can't find the > > corresponding command in Open Office. > > Anyone? > > Menu Edit - Find & Replace... Ctr + F > In that dialog, press "More options" and select "Regular expressions". > You may also press "Help" in order to read the Help files, in the Help > page look for "List of Regular Expressions", you see the list. > > Now, it depends on what you're trying to do. Are you trying to remove > empty paragraphs? or you simply want to find the end of each paragraph? > > To find empty paragraphs: ^$ > To find the end of the paragraph (the paragraph break): $ > > > > 2) I try to import data from an open office spreadsheet into a word > > processing document, simply by copying-and-pasting. But the data > > pasted in comes out in graphics format, and then I can't do anything > > with it. > > > > In MS-Word, the data came through in table format, and you could do > > what you want with it. > > Copy in Calc and Paste Special in Writer. > Paste Special is menu Edit - Paste Special Ctr + Up + V > You can also press the drop-down arrow in the paste tool bar icon. > Try selecting "Formatted Text [RTF]" or "HTML", see which suits you. > > > > Can anyone help? I thank you in advance. > > Regards > -- > Ariel Constenla-Haile > La Plata, Argentina > -- Martin du Saire Biological Sciences Technician USDA-ARS 470 Borlaug Hall 1991 Upper Buford Circle St. Paul, Minnesota 55108 612-625-9747 [email protected] -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help
