Skip to content

Commit d8cc76b

Browse files
gewarrengewarren
committed
acrolinx
1 parent 15605c8 commit d8cc76b

2 files changed

Lines changed: 8 additions & 7 deletions

File tree

‎docs/2014/relational-databases/scripting/search-text-with-regular-expressions.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -23,7 +23,7 @@ manager: craigg
2323

2424
#### To find using regular expressions
2525

26-
1. To enable the use of regular expressions in the **Find what** field during **QuickFind**, **FindinFiles**, **Quick Replace**, or **Replace in Files** operations, select the **Use** option under **Find Options**and choose **Regular expressions**.
26+
1. To enable the use of regular expressions in the **Find what** field during **QuickFind**, **FindinFiles**, **Quick Replace**, or **Replace in Files** operations, select the **Use** option under **Find Options** and choose **Regular expressions**.
2727

2828
2. The triangular **Reference List** button next to the **Find what** field then becomes available. Click this button to display a list of the most commonly used regular expressions. When you choose any item from the Expression Builder, it is inserted into the **Find what** string.
2929

@@ -58,7 +58,7 @@ manager: craigg
5858
|----------------|------------|-----------------|
5959
|Minimal - zero or more|@|Matches zero or more occurrences of the preceding expression, matching as few characters as possible.|
6060
|Minimal - one or more|#|Matches one or more occurrences of the preceding expression, matching as few characters as possible.|
61-
|Repeat n times|^n|Matches n occurrences of the preceding expression. For example, [0-9]^4 matches any 4-digit sequence.|
61+
|Repeat n times|^n|Matches n occurrences of the preceding expression. For example, [0-9]^4 matches any four digit sequence.|
6262
|Grouping|()|Groups a subexpression.|
6363
|nth tagged text|\n|In a **Find or Replace** expression, indicates the text matched by the nth tagged expression, where n is a number from 1 to 9.<br /><br /> In a **Replace** expression, \0 inserts the entire matched text.|
6464
|Right-justified field|\\(w,n)|In a **Replace** expression, right-justifies the nth tagged expression in a field at least *w* characters wide.|

‎docs/ssms/scripting/search-text-with-regular-expressions.md‎

Lines changed: 6 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -20,16 +20,17 @@ monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-s
2020
---
2121
# Search Text with Regular Expressions
2222
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
23-
Regular expressions are a concise and flexible notation for finding and replacing patterns of text. A specific set of regular expressions can be used in the **Find what** field of the [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] **Find and Replace** dialog box.
23+
24+
Regular expressions are a concise and flexible notation for finding and replacing patterns of text. A specific set of regular expressions can be used in the **Find what** field of the [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] **Find and Replace** dialog box.
2425

25-
#### To find using regular expressions
26+
## Find using regular expressions
2627

27-
1. To enable the use of regular expressions in the **Find what** field during **QuickFind**, **FindinFiles**, **Quick Replace**, or **Replace in Files** operations, select the **Use** option under **Find Options**and choose **Regular expressions**.
28+
1. To enable the use of regular expressions in the **Find what** field during **QuickFind**, **FindinFiles**, **Quick Replace**, or **Replace in Files** operations, select the **Use** option under **Find Options** and choose **Regular expressions**.
2829

2930
2. The triangular **Reference List** button next to the **Find what** field then becomes available. Click this button to display a list of the most commonly used regular expressions. When you choose any item from the Expression Builder, it is inserted into the **Find what** string.
3031

3132
> [!NOTE]
32-
> There are syntax differences between the regular expressions that can be used in **Find what** strings and those that are valid in [!INCLUDE[msCoName](../../includes/msconame-md.md)] .NET Framework programming. For example, in **Find and Replace**, the braces notation {} is used for tagged expressions. So the expression "zo{1}" matches all occurrences of "zo" followed by the tag 1, as in "Alonzo1" and "Gonzo1". But within the .NET Framework, the notation {} is used for quantifiers. So the expression "zo{1}" matches all occurrences of "z" followed by exactly one "o", as in "zone" but not "zoo".
33+
> There are syntax differences between the regular expressions that can be used in **Find what** strings and those that are valid in [!INCLUDE[msCoName](../../includes/msconame-md.md)] .NET Framework programming. For example, in **Find and Replace**, the braces notation {} is used for tagged expressions. So the expression "zo{1}" matches all occurrences of "zo" followed by the tag 1, as in "Alonzo1" and "Gonzo1". But within the .NET Framework, the notation {} is used for quantifiers. So the expression "zo{1}" matches all occurrences of "z" followed by exactly one "o", as in "zone" but not "zoo".
3334
3435
The following table describes the regular expressions available in the **Reference List**.
3536

@@ -59,7 +60,7 @@ monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-s
5960
|----------------|------------|-----------------|
6061
|Minimal - zero or more|@|Matches zero or more occurrences of the preceding expression, matching as few characters as possible.|
6162
|Minimal - one or more|#|Matches one or more occurrences of the preceding expression, matching as few characters as possible.|
62-
|Repeat n times|^n|Matches n occurrences of the preceding expression. For example, [0-9]^4 matches any 4-digit sequence.|
63+
|Repeat n times|^n|Matches n occurrences of the preceding expression. For example, [0-9]^4 matches any four digit sequence.|
6364
|Grouping|()|Groups a subexpression.|
6465
|nth tagged text|\n|In a **Find or Replace** expression, indicates the text matched by the nth tagged expression, where n is a number from 1 to 9.<br /><br /> In a **Replace** expression, \0 inserts the entire matched text.|
6566
|Right-justified field|\\(w,n)|In a **Replace** expression, right-justifies the nth tagged expression in a field at least *w* characters wide.|

0 commit comments

Comments
 (0)