Need Urgent Help on some expressions

General discussions about Advanced Find and Replace
Post Reply
az123az
Posts: 2
Joined: Wed Mar 01, 2006 10:59 am

Need Urgent Help on some expressions

Post by az123az » Wed Mar 01, 2006 11:28 am

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 "[..]"

Example1
[This is a test1]
This is a test2

or Example2 (one with next line - enter key)
[This is a
test1]
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

Darryl

az123az
Posts: 2
Joined: Wed Mar 01, 2006 10:59 am

Remove texts inclusive of []

Post by az123az » Thu Mar 02, 2006 6:36 am

Hi,

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

Thanks

Abacre
Site Admin
Posts: 1201
Joined: Mon Jan 31, 2005 5:32 pm
Contact:

Post by Abacre » Thu Mar 02, 2006 10:39 am

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).
Kind regards,
Abacre Limited
http://www.abacre.com
support@abacre.com

Post Reply

Who is online

Users browsing this forum: No registered users and 8 guests