Page History: Using Regular Expressions In The Replace Dialog - Visual Studio

Compare Page Revisions

8 7 6 5 4 3 2 1 0 Current 8 7 6 5 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Tue, Nov 09, 2010, 10:57 AM

Wrapping part of the Find What expression in curly braces allows you to refer to it in the Replace With expression via \number.

Example #1¶

For example, using

Find What	= Cells\("{[A-Za-z]*}"\)
Replace With	= Cells(\1.Name)

will replace	Cells("uxDefaultCheckboxColumn")
with	Cells(uxDefaultCheckboxColumn.Name)

Example #2¶

To transform SQL from this...

a.City + ', ' + a.State + ' ' + a.ZipCode as CityStateZip

to this...

CityStateZip = a.City + ', ' + a.State + ' ' + a.ZipCode

use these settings in the Find and Replace dialog

Find What	= ,{.+} as {.+}
Replace With	= ,\2 = \1