How do I replace with a wild card?

[ToddAndMargo]

Hi All,

I have a column populated with something like the following:
1.2.3.4:10017
1.2.4.4:49275
1.2.5.4:12343

How do I do a find and replace such that I get back:
1.2.3.4
1.2.4.4
1.2.5.4

Many thanks,
-T

[karolus]

search for :\d+$
replace with nothing

[ToddAndMargo]

It just turns the search term red:

[mikekaganski]

Did you enable regular expressions? Indeed, if you didn’t cut the screenshot so badly, we could see that ourselves…

[karolus]

@ToddAndMargo

It just turns the search term red:

did you check [x] regular Expression ?
if already done, change the search expression to

:\d+\s*?$

[ToddAndMargo]

Checking off Regular Expressions got rid of the red. :\d+\s*?$ did not work though

[karolus]

… and WHY did you not use the Replace All Button on the right??

[ToddAndMargo]

Ah bugger. I clicked find instead of replace! Thank you for the second pair of eyes.