DosTips.com

HI Dave -

This works great for me situation, many thanks!!!

Now I understand beggars can't be choosers, but this is running "slow" when cycling through a big file. Is this expected behavior? And by slow I mean about ~1 minute for a 3k row file.

Other than, absolutely fantastic!!

Antonio -

That worked wonderfully!! 16+ millions rows very quickly. Thank you again for this, much appreciated!!

Hi Aacini !

Thank you ! Basically I need to pull all the unique values in column 8. Is that possible?

HI Dave/Team - I have a text file that is 16 million rows and I need to extract the unique values from the 8th position of the file. "Property Gross Royalties" "Commercial" "Actual" "Final" "FY14" "Jan" "Periodic" "O-20003921" "FDR" "PA" 120 "Sides" "Commercial" "Actual" "Final" "FY14" "Jan" "Period...

Dave -

As usual, you are the man! Thank you so much for your help here! This has actually cascading into my updating a few of my other scripts as well based on the concept here.

Thank you again!!

In searching some old threads from Fox and others, this seems to be the preffered approach: @ECHO OFF ::-- If one or more Data Management CRITICAL Errors detected, build kickout file --:: FINDSTR /I /C:"ORA-"^ /C:"Fetch of Driver Member"^ /C:"Error: 3303"^ /C:"Error: 3304"^ /C:"Error: 3335"^ /C:"Err...

Hi Folks - I have the following logic that I need to check multiple strings. If 1 or more are found from my first check, then need to include other and spool all content to a file. The logic is working but wondering if there is a better way? Also, I'd like to use ORA- as one of my strings but the "-...

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!!

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