DosTips.com

In doing some research, I came up with this approach which get's me 90% there: :SELECT_BACKUP SET "DOTS=..." FOR %%A IN ("Daily" "Weekly" "Monthly" "Yearly") DO ( FOR /F "delims=" %%a IN ('DIR /S /B "%BACKUPPATH%%%A"') DO ( CALL :PROCESS "%%~a" ) ) :REPEAT CLS FOR /l %%A IN (1,1,%ZIP%) DO ( IF %%A l...

Hi Folks - I have a need to create a script that will display the folder contents from (4) different data backup folders I have. At most, there would only be 44 data files to choose from. I want the script to essentially cycle through each backup folder and display the content (with data modified) b...

Thank you, will do that!

To correct for now, I added a second sort with SORT /R.

HI Folks - I have the following script created to output unique values from a list. Prior to this step, I sort a single columntext file extracted from a data-dump from one of my data bases. From here, I need to pull out any unique records. The issue is when the uniq record is the LAST record, for so...

I arrived at this solution, although I'm not sure if it's as efficient as it can be: @ECHO OFF SETLOCAL ENABLEDELAYEDEXPANSION ( FOR %%F IN ("*.csv") DO ( REM Sort PERIOD Column in reverse order to get MAX value SET "MAX=" SET "MIN=" FOR /F "tokens=2,3 delims=," %%A IN ('SORT /R "%%F"') DO ( IF NOT ...

Hi Folks - What is the easiest way to determine the lowest and highest number from a specific column? Is it JSORT? I have a csv file with (3) columns. Column (2) is the column I need to check and the numbers will range from 01 to 12. Example: State,01,2018 State,03,2018 State,05,2018 State,01,2019 S...

Ah yes, very simple using the tokens.
THanks!

Hi Folks - I have a text file that looks like such: outbox/logs/PLAN - Custom_8001.log outbox/logs/PLAN - Custom_242.log outbox/logs/PLAN - Custom_243.log outbox/logs/PLAN - Custom_244.log outbox/logs/PLAN - Custom_245.log outbox/logs/PLAN - Custom_246.log outbox/logs/PLAN - Custom_40.log outbox/log...

Hi Antonio -

I see the code you posted on the new thread is a bit different than the one above - which one should be used?

Thank you!

I would like to present a simpler approach: @echo off setlocal EnableDelayedExpansion set /P "YYYYMMDD=Enter date in YYYYMMDD format: " set /P "days=Enter number of days: " set /A "DD=100+(D=YYYYMMDD%%100), YYYYMM=YYYYMMDD/100, MM=100+(M=YYYYMM%%100), YYYY=YYYYMM/100 for /L %%i in (1,1,%days%) do (...

Hi All -

Thank for the links! I'm been playing around with that but can't seem to get anything worth that would be dynamic enough. Was hoping this was a quick hit. Does anyone mind sharing an example I could extrapolate on?

Gracias!

Hi Folks - I have a unique need to implement a lag type of methodology. For instance, I have a date variable set as such: SET "DATEVAR=31-Jan-18" I also need to set (4) additional variable that lag 4 days. For instance: SET "DATEVAR1=30-Jan-18" SET "DATEVAR2=29-Jan-18" SET "DATEVAR3=28-Jan-18" SET "...

I played around and got this to work, but not sure if it's the most efficient? SET "CLOUD_URL=https://planning-z552xxx1.pbcs.us2.oraclecloud.com" SET "SEARCH=test" ECHO "%CLOUD_URL%" | FINDSTR /C:"%SEARCH%" >nul 2>&1 && ( SET "FLAG=T" ) IF DEFINED FLAG FOR /F "tokens=1,3 delims=-" %%A IN ("%CLOUD_UR...

Hi Folks - I have a variable defined as such: SET "CLOUD_URL=https://planning-z552xxx1.pbcs.us2.oraclecloud.com" What I need to do is if the variable above does not have the string "test" in it, I need to add it. Like such: SET "CLOUD_URL=https://planning-test-z552xxx1.pbcs.us2.oraclecloud.com" And ...