Delete between square brackets [closed]

asked 2013-03-09 08:34:03 +0100

flywire
49 ●5 ●10 ●14

updated 2020-08-16 12:57:33 +0100

Alex Kemp

flag of United Kingdom of Great Britain and Northern Ireland

20844 ●19 ●60 ●59 http://etmg.altervista...

How do I delete all text between square brackets (including the square brackets) in calc cells throughout the document?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-26 15:45:27.969033

add a comment

1

answered 2013-03-09 15:42:37 +0100

w_whalley

3837 ●6 ●22 ●45

In @mariosv's answer replace his [.*] with \[.*\]

edit flag offensive delete link

Comments

Right Whalley, I copy form LIbreOffice the expressión, and the esc \ are not showed.

m.a.riosv ( 2013-03-09 18:00:36 +0100 )edit

You can also use 4+ spaces to indent lines, which then gives syntax-highlighting (not so important in this case), monospace font, and (in most cases) no need to escape characters:

\[.*\]

qubit ( 2013-03-09 18:52:00 +0100 )edit

add a comment

1

answered 2013-03-09 12:44:21 +0100

m.a.riosv

25884 ●7 ●53 ●140

updated 2013-03-09 19:30:08 +0100

With find & replace (Ctrl+H),
in find: \[.*\]
in replace (nothing):
mark regular expressions,
Replace all.

edited: is needed \\ to show a \ here.

edit flag offensive delete link

add a comment

Delete between square brackets [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-26 15:45:27.969033

2 Answers

Comments

Question Tools

Stats

Related questions

Delete between square brackets [closed] edit

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2015-10-26 15:45:27.969033

2 Answers

Comments

Question Tools

Stats

Related questions

Delete between square brackets [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-26 15:45:27.969033