Issue 106099

Summary:	support regular expressions (regexps) in SUBSTITUTE function
Product:	Calc	Reporter:	Joe Smith <jes>
Component:	ui	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	issues, kamataki, peter.volkov
Version:	OOo 3.1.1
Target Milestone:	---
Hardware:	PC
OS:	All
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

Description Joe Smith 2009-10-20 16:15:10 UTC

It would be very useful if the SUBSTITUTE function could accept regular
expressions, as used in the Edit > Find & Replace dialog "Search for:" and
"Replace with:" fields.

Comment 1 mclaudt 2010-05-12 16:35:18 UTC

*** Issue 106099 has been confirmed by votes. ***

Comment 2 mclaudt 2010-05-12 16:39:21 UTC

It is ultimately important feature! There is a lot of unstructured data and only
regexp are capable to convert it no normal database form. With that function
OOCalc become the major tool for working with regexp.