Of course, you will need to adapt any RegEx to your specific use-case. Surely you wouldn't ask for automated support if there was only one example, and I wouldn't expect one example and a few words to actually tell everything needed to find a correct solution.
However, Find & Replace with a RegEx for the search and an appropriate replacement string would always work "in situ". With other words: It will destroy the original data. Therefore I prefer a solution based oin the REGEX() function.
If you insist on F&R, and you are sure your
very strange problem is sufficiently explained (what I can't believe), you can use
Code: Select all
(^.*"WordOne","mw":")(\d+\.\d+)(\|)(\d+\.\d+)(.*$)
as the search string and
as the replacement string.
I wouldn't suggest to use such RegEx related specialties without understanding them.
To play with examples, you should better use the REGEX() function.
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München