At 22:47 10/05/2008 -0700, Allen Noname wrote:
I have a rather large log file I need to get into a spreadsheet. Most I can handle just fine with search and replace but one search I can't figure out, the paragraph marker at the end of a line. In Word it is ^p. What is it in OO? The only thing I find is, "\n in the Search for text box stands for a line break that was inserted with the Shift+Enter key combination." I want to replace one or more spaces and the "enter" paragraph marker with just the paragraph marker. I know \n in the "Replace with" will do that part, but I don't know how to find the regular paragraph enter marker. I can't just replace spaces with nothing as that would make a jumble of the words in about 5000 lines.
OpenOffice Writer does not think of the paragraph marker itself as a character. Instead, you need to search just for the rogue spaces at the ends of your paragraphs, but require that they are indeed at the end of a paragraph. You do this using the $ character in a regular expression. In the Find & Replace dialogue, click More Options and tick "Regular expressions". Search for " +$" - that's space-plus-dollar - and replace with nothing. The space-plus part matches one or more spaces, and the dollar sign anchors the match to the end of a paragraph. Replacing just the spaces with nothing achieves what you need. (Remember that you have not matched the paragraph marker, which does not exist as a separate character.)
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
