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...
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...
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...
Compo - thanks for the reply and great question. The lines are not wrapped. It outputs to a file and I can confirm with 100% certainty lines are not wrapped.
Hi Folks - I have a need to extract a certain string from an output. What I do is spool all output from my command into a variable and then parse that variable. THe output varies in row count, it's never the same. But, the string in which I need to extract always has "logfilename" in the line. Here ...