DosTips.com

A Forum all about DOS Batch
https://www.dostips.com/forum/

Issue declaring an array and then using it's value

https://www.dostips.com/forum/viewtopic.php?f=3&t=9990

Page 1 of 1

Issue declaring an array and then using it's value

Posted: 12 Mar 2021 04:28
by SIMMS7400
Hi Folks -

I have an automation routine setup that performs a bunch of tasks. In all of my scripts, I first call an "environment" file to set a handful of variables for the given operation. In looking over my "environment" file, there is an opportunity to use an array to populate some variables to ensure it stays dynamic when porting over to another environment instead of having to edit each time.

The challenge is when setting up an array I need to use the command:
SETLOCAL ENABLEDELAYEDEXPANSION in the script but then when I call this "environment" script from my other scripts, obviously all variables set inside it are rendering nothing since they were local.

How do I get around this?

Here is the array in my "environment" script:

Code: Select all

@ECHO OFF
SETLOCAL ENABLEDELAYEDEXPANSION

FOR %%A IN (
	"HYPER-UTIL-PRD|PROD|net.tcp://HYPER-UTIL-aaa:5210/Oracle/Drm/ProcessManager|server1.client.com|server001.onetakeda.com"
	"HYPER-UTIL-TST|TEST|net.tcp://HYPER-UTIL-bbb:5210/Oracle/Drm/ProcessManager|server1.client.com|serverp002.onetakeda.com"
	"HYPER-UTIL-DEV|DEV|net.tcp://HYPER-UTIL-ccc:5210/Oracle/Drm/ProcessManager|server1.client.com|server003.onetakeda.com"
	) DO (
	
	FOR /F "tokens=1-5 delims=|" %%a IN (%%A) DO (
		SET "STR[%%a].HOST=%%a"
		SET "STR[%%a].ENV=%%b"
		SET "STR[%%a].DRM_URL=%%c"
		SET "STR[%%a].TM1_SERVER=%%d"
		SET "STR[%%a].TEMPO_SERVER=%%e"
	)
)

ECHO Host         = !STR[%COMPUTERNAME%].HOST!
ECHO Env          = !STR[%COMPUTERNAME%].ENV!
ECHO DRM URL      = !STR[%COMPUTERNAME%].DRM_URL!
ECHO TM1 Server   = !STR[%COMPUTERNAME%].TM1_SERVER!
ECHO Tempo Server = !STR[%COMPUTERNAME%].TEMPO_SERVER!

POWERSHELL -nop -c "& {sleep 5}"

::-- Set Environment --::
SET "_ENV=!STR[%COMPUTERNAME%].ENV!"

::--:::::::::::::::::::::::::::::::::--::
::-- SET PATH VARIABLES              --::
::--:::::::::::::::::::::::::::::::::--::

FOR %%A IN ("%~dp0..\..\..\..\Utilities") DO SET "UTILPATH=%%~fA\"
FOR %%A IN ("%~dp0..\..") DO SET "MAINPATH=%%~fA\"
SET "ARCHIVEPATH=%MAINPATH%Archives\"
SET "ERRORPATH=%MAINPATH%Errors\"
SET "FILEPATH=%MAINPATH%Files\"
And then I'm simply calling the above script as such from my other scripts:

Code: Select all

::-- Set Working Directory as Script Path --::
CD /D "%~dp0"

::-- Call Environment File --::
CALL "_env.cmd"
I need to still be able to access the variable inside my "environment" script. How would I go about doing this? Thanks!

Re: Issue declaring an array and then using it's value

Posted: 12 Mar 2021 04:43
by SIMMS7400
I think I got it. I need to set all of the variables with an array first and then implement and ENDLOCAL:

Code: Select all

@ECHO OFF
SETLOCAL ENABLEDELAYEDEXPANSION

FOR %%A IN (
"HYPER-UTIL-PRD|PROD|net.tcp://HYPER-UTIL-aaa:5210/Oracle/Drm/ProcessManager|server1.client.com|server001.onetakeda.com"
"HYPER-UTIL-TST|TEST|net.tcp://HYPER-UTIL-bbb:5210/Oracle/Drm/ProcessManager|server1.client.com|serverp002.onetakeda.com"
"HYPER-UTIL-DEV|DEV|net.tcp://HYPER-UTIL-ccc:5210/Oracle/Drm/ProcessManager|server1.client.com|server003.onetakeda.com"
) DO (

FOR /F "tokens=1-5 delims=|" %%a IN (%%A) DO (
SET "STR[%%a].HOST=%%a"
SET "STR[%%a].ENV=%%b"
SET "STR[%%a].DRM_URL=%%c"
SET "STR[%%a].TM1_SERVER=%%d"
SET "STR[%%a].TEMPO_SERVER=%%e"
)
)

ECHO Host = !STR[%COMPUTERNAME%].HOST!
ECHO Env = !STR[%COMPUTERNAME%].ENV!
ECHO DRM URL = !STR[%COMPUTERNAME%].DRM_URL!
ECHO TM1 Server = !STR[%COMPUTERNAME%].TM1_SERVER!
ECHO Tempo Server = !STR[%COMPUTERNAME%].TEMPO_SERVER!

POWERSHELL -nop -c "& {sleep 5}"

::-- Set Variables --::
SET "_ENV=!STR[%COMPUTERNAME%].ENV!"
SET "DRM_URL=!STR[%COMPUTERNAME%].DRM_URL!"
SET "TM1_SERVER=!STR[%COMPUTERNAME%].TM1_SERVER!"
SET "TEMPO_SERVER=!STR[%COMPUTERNAME%].TEMPO_SERVER!"

ENDLOCAL & (

SET "_ENV=%_ENV%"
SET "DRM_URL=%DRM_URL%"
SET "TM1_SERVER=%TM1_SERVER%"
SET "TEMPO_SERVER=%TEMPO_SERVER%"

)
Is this the correct way of going about it?

Re: Issue declaring an array and then using it's value

Posted: 12 Mar 2021 08:40
by T3RRY
Setlocal and endlocal aren't necessary for this task.
When you use Goto :Eof in a batch script, an endlocal is assumed if Setlocal has been used.

The values in the array can be accessed by using a for /F loop over the Set command, meaning delayed expansion is never required eliminating the need to pass variable back over the Endlocal Barrier.

A small set of files to illustrate:

Caller.bat

Code: Select all

 @Echo off
 Call Environ.bat "input.txt"
input.txt

Code: Select all

Data 1|Data 2|Data 3|Data 4|Data 5
Environ.bat

Code: Select all

@Echo off
 For /F "Tokens=1-5 Delims=|" %%a in (%~1)Do (
  Set "Current.Host=%%a"
  Set "Host[%%a]=%%a"
  Set "Env[%%a]=%%b"
  Set "DRM Url[%%a]=%%c"
  Set "TM1 Server[%%a]=%%d"
  Set "Tempo Server[%%a]=%%e"
 )
 For %%G in (Host Env "DRM Url" "TM1 Server" "Tempo Server")Do (
  For /F "Tokens=1,2 Delims==" %%i in ('Set "%%~G[%Current.Host%"')Do Echo(%%i = %%j
 )

Re: Issue declaring an array and then using it's value

Posted: 12 Mar 2021 11:30
by Compo
…and to do it using much the same method as you had:

Code: Select all

@ECHO OFF
SETLOCAL ENABLEEXTENSIONS DISABLEDELAYEDEXPANSION

FOR /F "DELIMS==" %%G IN ('"(SET STR[%COMPUTERNAME%].) 2>NUL"') DO SET "%%G="

SET "_ALL=:5210/Oracle/Drm/ProcessManager|server1.client.com|"
FOR %%A IN (
	"HYPER-UTIL-PRD|PROD|net.tcp://HYPER-UTIL-aaa%_ALL%server001.onetakeda.com"
	"HYPER-UTIL-TST|TEST|net.tcp://HYPER-UTIL-bbb%_ALL%serverp002.onetakeda.com"
	"HYPER-UTIL-DEV|DEV|net.tcp://HYPER-UTIL-ccc%_ALL%server003.onetakeda.com"
) DO FOR /F "TOKENS=1-5 DELIMS=|" %%a IN (%%A
) DO IF /I "%%a" == "%COMPUTERNAME%" (
   SET "STR[%%a].HOST=%%a"
   SET "STR[%%a].ENV=%%b"
   SET "STR[%%a].DRM_URL=%%c"
   SET "STR[%%a].TM1_SERVER=%%d"
   SET "STR[%%a].TEMPO_SERVER=%%e"
)

IF DEFINED STR[%COMPUTERNAME%].ENV (
	SETLOCAL ENABLEDELAYEDEXPANSION
	ECHO Host         = !STR[%COMPUTERNAME%].HOST!
	ECHO Env          = !STR[%COMPUTERNAME%].ENV!
	ECHO DRM URL      = !STR[%COMPUTERNAME%].DRM_URL!
	ECHO TM1 Server   = !STR[%COMPUTERNAME%].TM1_SERVER!
	ECHO Tempo Server = !STR[%COMPUTERNAME%].TEMPO_SERVER!
	REM -- Set Environment --
	FOR %%G IN ("!STR[%COMPUTERNAME%].ENV!") DO ENDLOCAL & SET "_ENV=%%~G"
)

TIMEOUT /T 5 /NOBREAK 1>NUL

REM ------------------------
REM -- SET PATH VARIABLES --
REM ------------------------

FOR %%A IN ("%~dp0..\..\..\..\Utilities") DO SET "UTILPATH=%%~fA\"
FOR %%A IN ("%~dp0..\..") DO SET "MAINPATH=%%~fA\"
SET "ARCHIVEPATH=%MAINPATH%Archives\"
SET "ERRORPATH=%MAINPATH%Errors\"
SET "FILEPATH=%MAINPATH%Files\"

Re: Issue declaring an array and then using it's value

Posted: 13 Mar 2021 03:54
by SIMMS7400
Hi Compo -

Thanks so much, that certainly cuts down on the amount of lines necessary. My only question is how would I set all my variables so I can access them?

You have set _ENV here, but how do I set all of them from above?

Code: Select all

FOR %%G IN ("!STR[%COMPUTERNAME%].ENV!") DO ENDLOCAL & SET "_ENV=%%~G"
Or should I just access them in this manner when needed? i.e. !STR[%COMPUTERNAME%].DRM_URL! ?
Thanks!

Re: Issue declaring an array and then using it's value

Posted: 13 Mar 2021 12:46
by Compo
Which variables? my code defined every variable yours did! and all of them are available within the calling script upon return to it.

But assuming that you really do not need all of the variable names with [%COMPUTERNAME%] in them, you've created them unnecessarily.

For example:

Code: Select all

@ECHO OFF
SETLOCAL ENABLEEXTENSIONS DISABLEDELAYEDEXPANSION

FOR /F "DELIMS==" %%G IN ('"(SET _) 2>NUL"') DO SET "%%G="

SET "_ALL=:5210/Oracle/Drm/ProcessManager|server1.client.com|"
FOR %%A IN (
	"HYPER-UTIL-PRD|PROD|net.tcp://HYPER-UTIL-aaa%_ALL%server001.onetakeda.com"
	"HYPER-UTIL-TST|TEST|net.tcp://HYPER-UTIL-bbb%_ALL%serverp002.onetakeda.com"
	"HYPER-UTIL-DEV|DEV|net.tcp://HYPER-UTIL-ccc%_ALL%server003.onetakeda.com"
) DO FOR /F "TOKENS=1-5 DELIMS=|" %%a IN (%%A) DO IF /I "%%a" == "%COMPUTERNAME%" (
   SET "_HOST=%%a"
   SET "_ENV=%%b"
   SET "_DRM_URL=%%c"
   SET "_TM1_SERVER=%%d"
   SET "_TEMPO_SERVER=%%e"
)

…

Re: Issue declaring an array and then using it's value

Posted: 14 Mar 2021 03:47
by SIMMS7400
Hi Compo -

I replaced my section with yours:

Code: Select all

SETLOCAL ENABLEEXTENSIONS DISABLEDELAYEDEXPANSION

FOR /F "DELIMS==" %%G IN ('"(SET STR[%COMPUTERNAME%].) 2>NUL"') DO SET "%%G="

SET "_ALL=:5210/Oracle/Drm/ProcessManager|server1.client.com|"
FOR %%A IN (
	"HYPER-UTIL-PRD|PROD|net.tcp://HYPER-UTIL-aaa%_ALL%server001.onetakeda.com"
	"HYPER-UTIL-TST|TEST|net.tcp://HYPER-UTIL-bbb%_ALL%serverp002.onetakeda.com"
	"HYPER-UTIL-DEV|DEV|net.tcp://HYPER-UTIL-ccc%_ALL%server003.onetakeda.com"
) DO FOR /F "TOKENS=1-5 DELIMS=|" %%a IN (%%A
) DO IF /I "%%a" == "%COMPUTERNAME%" (
   SET "STR[%%a].HOST=%%a"
   SET "STR[%%a].ENV=%%b"
   SET "STR[%%a].DRM_URL=%%c"
   SET "STR[%%a].TM1_SERVER=%%d"
   SET "STR[%%a].TEMPO_SERVER=%%e"
)

IF DEFINED STR[%COMPUTERNAME%].ENV (
	SETLOCAL ENABLEDELAYEDEXPANSION
	ECHO Host         = !STR[%COMPUTERNAME%].HOST!
	ECHO Env          = !STR[%COMPUTERNAME%].ENV!
	ECHO DRM URL      = !STR[%COMPUTERNAME%].DRM_URL!
	ECHO TM1 Server   = !STR[%COMPUTERNAME%].TM1_SERVER!
	ECHO Tempo Server = !STR[%COMPUTERNAME%].TEMPO_SERVER!
	REM -- Set Environment --
	FOR %%G IN ("!STR[%COMPUTERNAME%].ENV!") DO ENDLOCAL & SET "_ENV=%%~G"
and then in my calling script, the only variable I am able to use in %_ENV%. How do I access the other ones? I'm confused then.

Re: Issue declaring an array and then using it's value

Posted: 14 Mar 2021 06:10
by Compo
The decision to create variable names which include a nested variable was yours, so in order to use those variables, you must do so by implementing another layer of variable expansion.

However, you do not need to create variables named using a nested variable, and I clearly showed you that in my later response. Please read it, comprehend it, and implement it, instead of seemingly ignoring it in favor of a previous response.

Re: Issue declaring an array and then using it's value

Posted: 16 Mar 2021 18:40
by SIMMS7400
HI Compo -

I understand now. Yes, you are right I don't need to be as detailed as it was, unnecessary. I have used your suggestion and have been testing the last few days and everything is working as expected!! Thank you again!!
All times are UTC-06:00
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/