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, Oct 23, 2012, 2:56 PM

Visual Studio 2010¶

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

Visual Studio 2012¶

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

Example¶

For example, using

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

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

Changes since VS 2010¶

In Visual Studio 2012, the following changes were made

• In the Find what field, capture groups are now wrapped in parenthesis instead of curly braces.
• In the Replace with field, capture groups are now referenced via a dollar sign instead of a backslash.