How to know specific string exist or not in PowerShell?

Question

I want to verify the database for the given script in CI. I want to check specific string exists or not in the given file.

Below is the content of my file USE [SampleDB]

I am reading the content of my file and checking [SampleDB] string exists or not in the file.

I have tried the below things.

If(Get-Content -path D:/Document/admin.sql | Select-String -Pattern "[SampleDB]")
{
  # Right Database exist
} else {
  # Right Database does not exist
}

How can I verify the right database name after the USE string?

Mathias R. Jessen · Accepted Answer · 2023-01-17 11:55:01Z

1

Select-String uses regular expressions to perform string searches, and the construct [...] has a special meaning in that context - namely, it means "match any one of these characters", not quite what you're expecting.

To search for the word [SampleDB] verbatim you either have to escape it correctly:

# escape your search term!
$searchTerm = [regex]::Escape('[SampleDB]')

if(Get-Content -path D:/Document/admin.sql | Select-String -Pattern $searchTerm) {
  # Right Database exist
} else {
  # Right Database does not exist
}

... or you can request Select-String perform a non-regex match with the -SimpleMatch switch:

if(Get-Content -path D:/Document/admin.sql | Select-String -Pattern "[SampleDB]" -SimpleMatch) {
  # Right Database exist
} else {
  # Right Database does not exist
}

answered Jan 17, 2023 at 11:55

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to know specific string exist or not in PowerShell?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related