Avatar of D B
D B
Flag for United States of America asked on

Replacing a "tag" in a Variable with Value from Another

I have a parameter file in CVS format that I process within powershell scripts. The file is in the format of:
VariableName, Value
Several of the variables include the path to specific files. The 'root' of this path is always the same, and in one instance is used several times in a variable (it is actually the commandline parameters for an SSIS package, executed with DtExec.exe.

What I would like to do is have something like:
ROOT,C:\SomeFolder\SomeFolder2\SomeFolder3\HomeFolder
PACKAGE_CMD_LINE,/FILE "%ROOT%\MyPackage.dtsx" /CONFIGFILE "%ROOT%\MyConfig1.dtsConfig" /CONFIGFILE "%ROOT%\MyConfig2.dtsConfig"  /WARNASERROR  /CHECKPOINTING OFF  /REPORTING EWD /CONSOLELOG NCOT 

Open in new window

in my parameter file. Within Pwershell, it will set the values of $ROOT and $PACKAGE_CMD_LINE to the appropriate values. Then, within the code, I want Powershell to replace the '%ROOT%' "tags" within the $PACKAGE_CMD_LINE variable with the value of the $ROOT variable, which has already been processed. Can someone assist me as to how this might be accomplished.
Subsequently, I would have a line that reads:
& DtExec.exe $PACKAGE_CMD_LINE

Open in new window

But $PACKAGE_CMD_LINE would have had occurances of '%ROOT%' replaced with the value of $ROOT.
Powershell

Avatar of undefined
Last Comment
D B

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
D B

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Your help has saved me hundreds of hours of internet surfing.
fblack61