Page 1 of 1

How to: Remove text between AAA...BBB

Posted: Fri May 13, 2011 11:54 am
by DataMystic Support
Step 1. Add Filters\Replace\Find EasyPattern.

To remove text between AAA...BBB, use EasyPattern:

Code: Select all

AAA[ 1+ chars ]BBB
Replace with nothing.

If you want to keep the AAA and BBB and insert new text, use EasyPattern:

Code: Select all

[ capture( 'AAA' ), capture( 1+ chars ), capture( 'BBB' ) ]
Replace with

Code: Select all

$1$new text$3$
If you want to find text between AAA and BBB and change AAA and BBB while keeping the inside text, use EasyPattern:

Code: Select all

[ capture( 'AAA' ), capture( 1+ chars ), capture( 'BBB' ) ]
Replace with

Code: Select all

newAAA$2$newBBB
See: http://www.datamystic.com/easypatterns_reference.html

If you have ideas for more 'How To's' please drop a note in the forums or send us an email.