Filter a file based on an object of string

Question

I have a SQL restore script (file on file system) that contains a list of databases to be restored like so:

RESTORE DATABASE DB1... RESTORE DATABASE DB2... RESTORE DATABASE DB3...

I then have an object that contains a list of databases that are already online.

$onlineDatabases.Database outputs DB1 DB2

How can I return a new restore script that contains only the DB3 database?

mjolinor · Accepted Answer · 2011-06-06 11:01:55Z

1

$online_databases = new-object psobject -property @{database = @("DB1","DB2")}
$test_script = "RESTORE DATABASE DB1","RESTORE DATABASE DB2","RESTORE DATABASE DB3"

[regex]$online_regex = "RESTORE DATABASE " + '(‘ + (($online_databases.database |foreach {[regex]::escape($_)}) –join “|”) + ‘)’
$new_script = $test_script -notmatch $online_regex

$new_script

RESTORE DATABASE DB3

Replace the $test_script with get-content on your script file, and pipe $new_script to out-file to save it.

answered Jun 6, 2011 at 11:01

mjolinor

68.7k7 gold badges118 silver badges141 bronze badges

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

4 Comments

Mizzle-Mo Over a year ago

When I run this in my script, $new_script returns True instead of the script.

Mizzle-Mo Over a year ago

Scratch that it was a PowerShell ISE fail. It is returning nothing. I will see if I can figure it out.

mjolinor Over a year ago

Here's an explanation of that regex if it helps: blogs.technet.com/b/heyscriptingguy/archive/2011/02/18/…

Mizzle-Mo Over a year ago

Thanks man, I had to tweak it a bit because there was something wrong with my object. I think because Database was listed as a NoteProperty? I had to use $onlineDatabases and then convert your Regex to a string and then find and replace on {Database= to "" and on } and on \@ after I did that it worked!!!! Thanks man, I don't know why my search skills didn't turn up the link, but you helped me get unblocked on my project. I appreciate it.

Collectives™ on Stack Overflow

Filter a file based on an object of string

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related