Skip to content

Commit 53835fd

Browse files
markingmynamemarkingmyname
committed
restructured steps.
1 parent d8b393e commit 53835fd

1 file changed

Lines changed: 13 additions & 5 deletions

File tree

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

Lines changed: 13 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@ ms.reviewer: randolphwest
77
ms.date: 07/11/2024
88
ms.service: sql
99
ms.subservice: ssms
10-
ms.topic: conceptual
10+
ms.topic: how-to
1111
f1_keywords:
1212
- "vswildcardsbuilder"
1313
- "vsregexbuilder"
@@ -24,17 +24,25 @@ helpviewer_keywords:
2424
monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
2525
---
2626

27-
# Search text with regular expressions
27+
# How to search text with regular expressions
2828

2929
[!INCLUDE [SQL Server Azure SQL Database Synapse Analytics PDW](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
3030

3131
The following regular expressions can replace characters or digits in the **Find what** field of the [!INCLUDE [ssManStudioFull](../../includes/ssmanstudiofull-md.md)] **Find and Replace** dialog box.
3232

33-
## Search using regular expressions
33+
## Prerequisites
3434

35-
1. To enable the use of regular expressions in the **Find what** field during **Quick Find**, **Find in Files**, **Quick Replace**, or **Replace in Files** operations, select the **Use** option under **Find Options** and then choose **Use Regular Expressions**.
35+
- [Download SSMS](../download-sql-server-management-studio-ssms.md)
3636

37-
1. The **Expression Builder** button next to the **Find what** field then becomes available. Select this button to display a list of the available regular expressions. When you choose any item from the **Expression Builder**, it's inserted into the **Find what** string.
37+
## How to enable regular expressions
38+
39+
Here are steps to enable regular expressions in search.
40+
41+
1. Go to **Edit** > **Find and Replace** > **Quick Find**.
42+
1. Next to the search bar select the *down arrow* > **Find in Files**.
43+
1. In the **Find and Replace** window expand **Find options** and select **Use Regular Expressions**.
44+
45+
The **Expression Builder** button next to the **Find what** field then becomes available. Select this button to display a list of the available regular expressions. When you choose any item from the **Expression Builder**, it's inserted into the **Find what** string.
3846

3947
The following table describes some of the regular expressions in the **Expression Builder**.
4048

0 commit comments

Comments
 (0)