Multi tool use

Batch Script to compare data

Every day in my team a group of people extract a report from a portal and name it like ABC_23MAY2018.txt,XYZ_23MAY2018.txt and save it in a directory.

ABC_23MAY2018.txt

XYZ_23MAY2018.txt

But because it is a manual process people do mistake like they extract the report of 22MAY2018 (giving the wrong date on the portal input) and name it ABC_23MAY2018.txt etc.
This has caused of lots of issues as the file is used for reports purposes. I was thinking to create a batch script which will extract the date from the file name -23MAY2018 and compare it with the date which will be extracted in another file date.txt. I have figured out to extract the date from file name :

22MAY2018

ABC_23MAY2018.txt

23MAY2018

set Filedate=ABC*.csv
for /f %%A in ('dir /b %Filedate%') do (
set filename=%%~A
set fileCSV=!filename:~9,10!
echo !filename:~9,10!
)


But how to compare it with the date in the file. for example, after extracting the date from filename its need to be compared it with the data.txt data which have value like :

ABC,23MAY2018
XYZ,23MAY2018


so the date extracted from ABC_23MAY2018.txt need to be compared with the first line and the second column have the date. If they are equal move the file in another directory.

ABC_23MAY2018.txt

How do I achieve it? Hope I explained my problem well.

1 Answer
1

I 'd use.

%%A

_

%%B

%%C

"Name,Date"

Technically the two for, the findstr and move could be on one line,
but that's more difficult to follow.

@Echo off
set "Filedate=ABC*.csv"
set "Destfolder=X:whereever"
for %%A in (%Filedate%) do (
for /f "tokens=1*delims=_" %%B in ("%%~nA") Do (
findstr /IBELC:"%%B,%%C" date.txt 2>&1>NUL && Move "%%A" "%DestFolder%"
)
)


2>&1

>Nul

&&

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.