Ask Your Question

How to find and replace a string including wildcards in Calc?

asked 2019-07-14 17:16:51 +0100

broadsworde gravatar image

updated 2020-08-16 12:20:34 +0100

Alex Kemp gravatar image

I have a Calc spreadsheet which I copied and pasted from Wikipedia. It has a bunch of citation links in the form of "[num]".
Something like "some data I want to keep [1] [12]".

How do I use Find and Replace (CTRL+H) to replace everything that starts with a "[" and ends in a "]" with a "wildcard" or any integer between them?

I've tried the: Other options > Wildcards check box, using "." as any character wildcard, but that doesn't work.

Any assistance would be very much appreciated.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-07-14 17:48:46 +0100

Opaque gravatar image

updated 2019-07-14 18:38:43 +0100


it's not about "Wildcards" but "Regular Expression". For your example

Find: \[[:digit:]*\]
Replace: Put your replace text here (no input here will remove the matches)
Other Options: Tick Regular Expressions

image description

edit flag offensive delete link more


On my screen it looks like your screenshot is covering the last bit of your text. So if you could fix that please; I want to understand and I don't. Thanks.

mrjjacobs gravatar imagemrjjacobs ( 2020-04-11 14:39:34 +0100 )edit

I assume the partly hidden text row is just part of a screen in screenshot not intended to be seen (not accurately enough cropped). You are not supposed to see the text that is partly hidden by the "search & replace" dialog box. There is nothing to be seen there.

-PSi- gravatar image-PSi- ( 2020-09-23 10:55:44 +0100 )edit

@-PSi- - you are right. Absolutely not important here and mrjjacobs would have noticed, if just trying what the answer states.

Opaque gravatar imageOpaque ( 2020-09-23 13:18:57 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-07-14 17:16:51 +0100

Seen: 1,214 times

Last updated: Aug 16