powershell - inline variable replace

Question

I have a SQL script that contains statements such as the following:

CREATE GROUP $MyGroup;
CREATE USER $MyUser;

Is there a way using Powershell that I can echo out the file contents with those variables replaced with their current values as set previously?

So if I had previously issued:

$MyGroup = 'group';
$MyUser = 'user';

the resultant string, after reading the file contents and substituting the variables, would be:

CREATE GROUP group;
CREATE USER user;

carlpett · Accepted Answer · 2014-03-18 14:23:24Z

3

Yes, through the $ExecutionContext you can access the ExpandString function:

$fileContents = Get-Content myfile.sql
$ExecutionContext.InvokeCommand.ExpandString($fileContents)

answered Mar 18, 2014 at 14:23

carlpett

12.7k5 gold badges52 silver badges83 bronze badges

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

1 Answer 1