Search and replace regular expression in Open Office calc

regex openoffice.org expression openoffice-calc
Chris8080 picture Chris8080 · Jul 31, 2010 · Viewed 12.3k times · Source

I've got something like this (in Open Office Calc):

Streetname. Number
Streetname. Number a

etc. Now I want to delete everything in front of the number. So I need to do a search and replace I guess. ^.*?([0-9]) this one matches Streetname. Number .. but what should I put in the replace field? If I do the search and replace, it deletes everything within the datafield :(

Answer

True Soft picture True Soft · Jul 31, 2010

In Search for field, write the following regex: (.*?[:space:])([0-9]+)

And in Replace with, write: $2

That means that you search for:

  1. any characters followed by a space
  2. one or more digits.

Replace all that with $2 - the reference to the digits.

It will replace Streetname. Number 24 with 24. Why did you put a in your example?

Related questions

Regular expression to match a line that doesn't contain a word

I know it's possible to match a word and then reverse the matches using other tools (e.g. grep -v). However, is it possible to match lines that do not contain a specific word, e.g. hede, using a regular …

Read More
How to validate an email address in JavaScript

Is there a regular expression to validate an email address in JavaScript?

Read More
RegEx match open tags except XHTML self-contained tags

I need to match all of these opening tags: <p> <a href="foo"> But not these: <br /> <hr class="foo" /> I came up with this and wanted to make sure I've got …

Read More