To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=60029 Issue #:|60029 Summary:|Replacing placeholders after finding a regular |expression Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|PC URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|editing Assigned to:|spreadsheet Reported by:|rnhainsworth
------- Additional comments from [EMAIL PROTECTED] Wed Jan 4 08:00:49 -0800 2006 ------- OpenOffice 2 'find and replace' lacks crucial functionality I need to be able to replace groups of characters when importing stuff into a spreadsheet. Find allows regular expressions. Replace will not substitute in parts of the expression. This was an issue mentioned when I used OO 1. I have recently reviewed issues in OO 2 and I find no movement on the issue. Suppose imported text has dates in the format MMM dd, '02 which are imported (from eg. Quick Books csv files) and I want them to be interpreted as dates in OO. I want to be able to do something like: find string: (...) ([0-9][0-9]), '([0-9][0-9]) replace string: \2-\1-\3 The find string is possible, though note the [0-9] instead of more normal \d which is not recognised in OO2. There is no functionality for the replace. However, it is standard for perl. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]