5

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 :(

chx
  • 11,270
  • 7
  • 55
  • 129
Chris8080
  • 53
  • 1
  • 1
  • 3

1 Answers1

10

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?

True Soft
  • 8,675
  • 6
  • 54
  • 83