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
Need Urgent Help on some expressions
Remove texts inclusive of []
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
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
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).
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).