Page 1 of 1

Need Urgent Help on some expressions

Posted: Wed Mar 01, 2006 11:28 am
by az123az
Hi all,

I was recommended by my friend to use this good software.
Currently I have a Excel file.
I need to removed the line with text inclusive of brackets "[..]"

[This is a test1]
This is a test2

or Example2 (one with next line - enter key)
[This is a
This is a test2

Result is
This is a test2

Can anyone kindly assist? I am not a programmer, so it is difficult for me to understand how to derive the codes other than basic text replace.

Thanks in advance


Remove texts inclusive of []

Posted: Thu Mar 02, 2006 6:36 am
by az123az

I tried \[[^\]]*\] using regular expression builder and it works to some extent.

Apparently can we replace it with a backspace key? (someone please highlight the code - thanks)

When I use the Batch replace row - nothing happen when try to look in Excel file.
If I export some data out into text file - it does detect and replaced.
I would be easier if it can detect the excel file and change the data inside.

Btw can I specified which field to change in Excel - e.g. column K only


Posted: Thu Mar 02, 2006 10:39 am
by Abacre
In fact the problem is the following:

Perl-style regular expressions on Batch replace tab
are applied for text files (*.txt, *.html, *.csv) only.
For Excel files: as you said you may export it into *.csv or *.txt
file for example. Then you may easily solve the task (let us know if
you need a help in constructing your regular expression).