On Mon, 2005-01-31 at 12:26 +1300, Ian Laurenson wrote: > Yes in the General Use Differences chapter of the Migration Guide. > There is also a section In Spreadsheet differences for using AutoFilter. > > Copied from Use Differences chapter: > > Regular expressions > > âRegular expressionsâ are significantly different in OpenOffice.org from > Microsoft Office's âUse wildcardsâ. See Help > Index tab > type in > âregular expressionsâ. Some common examples are in Table 1. To use > regular expressions, make sure the Regular expressions checkbox is > checked. On reopening the Find / Replace dialog the Regular Expressions > checkbox is always unchecked. > > Note: The asterisk â*â means any number of the preceding character so > where in Microsoft Office you might have just â*â the equivalent in > OpenOffice.org is â.*â as â.â stands for any single character (like > Microsoft Office's â?â). > > A macro that makes it easier to use regular expressions in Writer, and > allows searching for âpage breaksâ and for things like multiple blank > paragraphs, is available in a document called IannzFindReplace.sxw > available from http://homepages.paradise.net.nz/hillview/OOo/. >
Works well, thanks. > > Table 1. Sample regular expressions > > Description; Search; Replace > Replace multiple tabs with just one tab ;\t*;\t > > Replace multiple spaces with just one space. â[:space]â finds both > non-breaking spaces and normal spaces but not tabs (help is currently > incorrect). Type a normal space in the Replace field.;[:space:]*; Ian, Please check that 1.9 help is correct. It is doubtful that 1.1.x Help will be corrected. > [snipped] -- Documentation Co-Lead PLEASE - keep list traffic on the list. Email sent directly to me may be ignored utterly. "Dinna meddle wi' things ye ken nuthin' aboot!" J.Herriot
