DosTips.com

Squash -

Absolutely I can. But there will be situationnwhere I won't have the delimiter to use and will be stuck with this situation that I'm hopping to solve with some additional logic

Thanks, T, but that didn't work.

Lets say I have FDRBS_20210912.csv. it's still returning the array definition for the FDR line, not the FDRBS definition.

Thanks, T! Where would I add that character? To the array itself when it initializes?

Hi Folks - I have a unique situation that I'm wondering how to solve. I have an array and i'm initializing as follows: FOR %%a IN ( "FDR|DLR_DATA_FDRII,DLR_DATA_FDRII|inbox/LOC_DATA_FDRII|REPLACE|STORE_DATA" "FDRBS|DLR_DATA_FDRII,DLR_DATA_FDRII|inbox/LOC_DATA_FDRII|REPLACE|STORE_DATA" "FDRCS|DLR_DAT...

Gotchya, Shadow. Makes sense. I'll update my script and retry.

Thank you for the feedback!

HI Folks - I have the following logic: ::-- Run Pre Rule(s) based on criteria --:: SET "RUN_OBJECT=" IF /I "[%POV_CNT%]"=="[0]" ( SET "RUN_OBJECT=" FOR %%A IN (%DM_D_POV_LIST:,= %) DO IF DEFINED %%~A IF /I "[%CNT%]"=="[1]" SET "RUN_OBJECT=T" IF /I "[%%~A]"=="[DM_D_FN_POV]" SET "RUN_OBJECT=T" FOR %%A...

Hi Team - I have a process where I set a variable in batch but then want to reset back to another value from a PowerShell process that I'm executing but can't seem to get it to work. Here is my logic: SET "PRE_NOTIFY=T" & CALL :EMAIL Which calls this: :EMAIL ::-- Set Distribution List --:: IF NOT DE...

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