Find and replace a string using regular expressions
When you want to search and replace specific patterns of text, use regular expressions. They can help you in pattern matching, parsing, filtering of results, and so on. Once you learn the regex syntax, you can use it for almost any language.
-
Press Ctrl+R to open the search and replace pane.
Select the Regex checkbox to enable the regex syntax. If you need to check the regex syntax reference, click the question mark next to the Regex.
-
Enter a search string in the top field and a replace string in the bottom field.
-
When you search for metacharacters such as
.[{()\^$|?*+
, you need to escape them with backslash\
, so they can be recognized.For example, if you need to find
.
, type\.
in the search field. -
DataGrip can also match a letter case when you enter a range of characters in your search field.
For example, if you want to search for only uppercase characters, type the following in the search field:
\b[A-Z]To search and replace more complicated patterns, use the structural search and replace.
If the Match Case checkbox is cleared, DataGrip searches for both lower and upper cases. Select the Match Case checkbox to match the case of the specified range.
When you browse the occurrences, DataGrip displays the replacement hints, so you can view the potential results before clicking the Replace button.
Use regex capturing groups and backreferences
You can put the regular expressions inside brackets in order to group them. Each group has a number starting with 1, so you can refer to (backreference) them in your replace pattern. Note that the group 0 refers to the entire regular expression.
Let's consider the following code:
Open the search and replace pane Ctrl+R.
In the search field, enter parentheses
()
that would indicate a capturing group, for example:\stitle="(.*)?"\s*(/>*)
In the replace field, backreference such groups by numbers starting with 1, for example:
$2<title>$1</title>DataGrip highlights the found occurrences based on your search specifications and displays hints with the replace string.
Switch the character case
You can use regular expressions to change the case of characters that matches some criteria.
Open the search and replace pane Ctrl+R. Make sure that the Regex checkbox is selected.
In the search field enter the search pattern.
-
In the replace field, depending on what you want to achieve, enter one of the following syntax:
\l
changes a character to lowercase until the next character in the string.
For example,Bar
becomesbar
.\u
changes a character to uppercase until the next character in the string.
For example,bar
becomesBar
.\L
changes characters to lowercase until the end of the literal string\E
.
For example,BAR
becomesbar
.\U
changes characters to uppercase until the end of the literal string\E
.
For example,bar
becomesBAR
.
The following SQL code fragment is used as an example for this tutorial.
Find and replace a string
Open an SQL file with the example code, press Ctrl+R. The Replace pane appears at the top of the code editing window.
Select the Regex checkbox.
In the search field, type the following regular expression:
\(select dept.*?= (.*)\)In the Replace field, type
$1
(for more information, see capture groups).Click Replace, or Replace All.
Changing character case
Description | Regular expression for the replace field | Result |
---|---|---|
Change to upper case | \U$1 | 'ADMINISTRATION' |
Change to lower case | \L$1 | 'administration' |
Change the first letter to lower case | \l$1 | 'administration' |