How to list the results of a regex search in a directory?

Question

How to list the results of a regex search in a directory?

Navigation

#1 by (2 votes)
#2 by (2 votes)
#3 by (0 votes)

9

I have a directory with some C # files. In these files there are several SQL query codes.

I need to list all SELECT statements in these files using PowerShell. Commands start with SELECT and end with ; and can have more than one line, as an example:

SQL = "SELECT t.a, t.b, t.c FROM uf_GetResultSet(4, 1, 0, 0, 'G', 0, 0, 0) t";
(...)
SQL = "SELECT t.a, t.b, t.c" + 
      "FROM uf_GetResultSet(4, 3, 0, 0, 'C', " + idSomeThing.ToString() + ", 0, 0) t";

The default regex SELECT .+[\r\n]*.+"; fits me perfectly using Notepad ++, but I do not know how to adapt it in PS.

regex powershell

asked by anonymous 15.01.2014 / 15:04

3 answers

What is the difference between 'for x in y' and 'Enumerable # each'? Thread control to prevent lock

score 2 · Answer 1

I came to the following command:

PS> select-string -path *.cs -pattern "(?smi)(?<sql>SELECT .+?);" | foreach {$_.matches} | foreach {$_.groups['sql']} | select value

But it returns the SELECTs of only one line.

score 2 · Answer 2

If you do not need to list the lines where the selects are, you can use the code below:

$arquivos = Get-Content *.cs | Out-String
$selects = [Regex]::Matches($arquivos, "(?si)(SELECT.+?;)")
$selects | Select-Object -Expand Value

Since you want to fetch SELECTs that start in one row and end in another, the first step is to turn the various Get-Content rows into one with the Out-String cmdlet.

The second step is to use the .NET System.Text.RegularExpressions.Regex class via the [Regex] accelerator, since it is able to return all matches of a string, unlike the -match operator.

score 0 · Answer 3

I do not quite understand what you want to do (because of foreachs), because you only have to use the select-string that will theoretically work: select-string -path * .cs -pattern "(? smi) (" SELECT. + ");"