Since regexp are already supported well enough to use in functions like COUNTIFS, why plain regexp match couldn't be used as a function usable in a formula?
This would make extraction of a desirable substring simple in most situations (even with positive/negative lookahead/lookbehind regexps), without either requiring more custom functions or unnecessarily complication.
Steps to Reproduce:
I want to parse a value out of text — e.g. the text in column $I may contain "SomeTrait" and if so, my goal is to extract value 123. I need a formula to fill a long column.
I'll end up with something like
in one column ($Z), and then
=IF($Z2>0,VALUE( MID($I2,$Z2+LEN("SomeTrait["),FIND("]",$I2, $Z2)-LEN("SomeTrait[")-$Z2) ),0)
in another, and still have to pre- sanitize text so it won't fail due to containing "Trait " instead, or make it even more complicated.
Every time a string needs parsing, this involves unnecessarily complex constructs made of LEFT()/MID()/RIGHT(), FIND/SEARCH() and LEN() that have to either be repeated with the same arguments or consume half a dozen columns as temporary variables, just to parse this one value (and there are more of them).
matches "123". Just find the right cell, extract desired text from it, process it. Two functions, fairly transparent… regexps may be not always quite obvious, but at least short enough to analyze as a whole, and often easy to manually test (if something works in search, it will work in a formula too).
User Profile Reset: No
Any opinion here ?
(In reply to Xisco Faulí from comment #1)
> Hello Winfried,
> Any opinion here ?
Starting with LO version 6.2.0 Calc has the function REGEX, which matches text against a regular expression and optionally replaces text.
Therefore I set this bug report to resolved/duplicate.
*** This bug has been marked as a duplicate of bug 113977 ***