DosTips.com

Hi Folks - I have the following array (well, I believe it's technically called a "list): @echo off setlocal EnableDelayedExpansion FOR %%A IN ( "CITY.txt|CITY_JOB|CITY_Errors.zip|" "COUNTY.txt|COUNTY_JOB|COUNTY_Errors.zip|2" "REGION.txt|REGION_JOB|REGION_Errors.zip|1" ) DO SET "GROUP=%%~A" & CALL :D...

Well, I figured out a way to do it and it's working as expected although not sure if this is an acceptable approach. Essentially, I"m running over the files first before I process them to check an array definition I set. If a specific OLU_TYPE is set, then modfy the data modify. Then, when I begin t...

HI Antonio - Yes you're right, allow me to provide some more context! 1. Can be any number of files (1-1000) 2. Can have diferent extensions 3. The "first files" can be processed in any order so long as they are processed BEFORE the others 4. I have a list (or an array) setup which defines the files...

HI All - I have a data process I'm building for a client. All files are staged in a single directory so I'm using a for loop to consume all files and process accordingly. However, there are certain files I need to process first just to requirement from within the target application that I"m importin...

Antonio - Thank you very much! I understand now. This certainly increases the risk of errors (if the line isn't truly blank) etc. I will work with it for now and the conver to your other method. Which I have a question on, how do I sent multiple "data" lines? For instance, what if I have 5 "data" li...

If I put double quotes around it, it works (doesn't bomb) but then the value has two sets of quotes instead of one...hmmm DLR_DATA_FDRII1,DLR_DATA_FDRII1 inbox/LOC_DATA_FDRII Mode=""REPLACE Data"" If I do this, it works, but seems a bit clunky to remove the quotes: FOR %%a IN ( "FDR|DLR_DATA_FDRII,D...

HI Aacini - Thank you very much!! I really like your methodology and I'm going to poke around with it now! In the mean time, I still need to leverage my current methods until I'm able to make the switch. With that said, I do believe I still need my first for loop otherwise it does not cycle through ...

Aacini - that worked like a charm!! Thank you!!

HI Folks - I have the following text file that is an output from a data load process I run. I need to scan the file and if an instance of "| Error: " is found, I need to create another file with a header and applicable rows. Here is my file which I have pulled out at the etra garbage to keep it shor...

Thank you, Terry!! Your suggestion is working great for me!!

Found a couple old threads and this is what I came up with: @ECHO OFF SETLOCAL ENABLEDELAYEDEXPANSION FOR %%a IN ( "FDR|DLR_DATA_FDRII,DLR_DATA_FDRII|inbox/LOC_DATA_FDRII||STORE_DATA" ) DO FOR /F "eol=' delims=" %%G IN ("%%a") DO ( SET "L=%%~G" REM add a backslash (or other character) in front of ev...

Hi Folks - This may be a stupid question. I have the following array: FOR %%a IN ( "FDR|DLR_DATA_FDRII,DLR_DATA_FDRII|inbox/LOC_DATA_FDRII|REPLACE|STORE_DATA" ) DO FOR /F "tokens=1-4 delims=|" %%A IN (%%a) DO ( SET "STR[%%A].DLR=%%B" SET "STR[%%A].LOC=%%C" SET "STR[%%A].IMP=%%D" SET "STR[%%A].EXP=%%...

Thanks Squash and Aacni - both options worked great!

Squash, thank you sir. That seemed to do the trick!!

Now one more question, if perhaps the string on the RIGHT side of the file, like this:

20210913_FDRBS.csv

Is it also possible to search that way too?

Thanks, Squash! What do you mean "subtract"?

I'll also review the threads on how to properly break out of a loop.