Issue 106099 - support regular expressions (regexps) in SUBSTITUTE function
Summary: support regular expressions (regexps) in SUBSTITUTE function
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 3.1.1
Hardware: PC All
: P3 Trivial with 17 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-10-20 16:15 UTC by Joe Smith
Modified: 2013-06-16 16:33 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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.