Ask Your Question

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

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

broadsworde 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 +0200

Opaque gravatar image

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


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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 68 times

Last updated: Jul 14