DosTips.com

Hi Compo - I replaced my section with yours: 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%...

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? FOR %%G IN ("!STR[%COMPUTERNAME%].ENV!") DO ENDLOCAL & SET "_ENV=%%~G" Or ...

I think I got it. I need to set all of the variables with an array first and then implement and ENDLOCAL: @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|TE...

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 e...

Hi Dave -

I used the following and it seems to work: Do you forsee any issues with this update?

Hi Dave - I just tried the suggestion but unfortunately doesn't seem to work. Here are the contents of my first column, could the comma be causing an issue? CALL "%UTILPATH%Batch\JREPL" "^((?:[^|]*\|){17})\s*(?=$|\|)" "$1Projected Start Date Missing" /A /exc "1,'(USE FOR TERM)|'b" /f "%FDMEE_BIN%%DA...

HI Dave - I'm hoping this would be an easy tweak but there is a new business need. Per the above JREPL solution you suggested, it's working like a charm!! I do need to add a piece of logic that ignore certain rows that contain a specific string, is that possible? If the first column contains a strin...

Thanks, A. It was a new development or else I would have revealed in the beginning

Thanks for your time, this is fantastic!!

One last question, how do I get this value into a variable?

HI Antonio - Thank you for that suggest. I really do like how you're setting the array definition, nice and clean. One thing I'm running into is that I do have situation where there are multiple Entities which are comma delimited. How would I include them? Do I include them with another delimters an...

Historically, I've done something like @echo off setlocal EnableDelayedExpansion rem Define the set of applications set "app[AA].target_application=Application1" set "app[AA].target_entity=Entity1" set "app[BB].target_application=Application2" set "app[BB].target_entity=Entity2" set /P "dataFile=En...

Simple. Just use an array: @echo off setlocal EnableDelayedExpansion rem Define the set of applications set "app[AA]=Application1" set "app[BB]=Application2" set /P "dataFile=Enter data file: " echo The application is: !app[%dataFile:~0,2%]! Antonio Thank you Antonio! This is great, didn't realize ...

Hi Folks - I have a situation where I am loading files to a target Oracle system. The first two letters of the data file dictate the Target application. Rather than extracting the first two letters of the data file then cycling through a bunch of IF ELSE IF logic, is there a way to create a mapping/...

Hi Folks - I have the following command that executes an Oracle utility: CALL C:\path\to\util\utility.bat operation Param1 Param2 Param3 Param4 Param5 Param6 && ( ECHO Successful : Execute Data Load Rule ) || ( ECHO Failed : Execute Data Load Rule ) The utility is java based. What it does is while e...

Compo -

This works like a charm! Will do some more testing but so far so good, Thank you so much!!!

HI Antonio - Thank you so much! So for the most part, there should always b e those two conditions (the two slashes for the date at the beginning as well as the two slashes just before the <name_XXXX>.log. However, to ensure it's dynamic, is there a way to extract the string based on the other strin...