Stop a line item from passing into file using .bat process

Job ID: 32543690

Budget: $30 – $50 USD

have a .bat file that will split one file into separate files based on a change in the first column. This works perfectly fine but the client wants to prevent any records going into the file if the 3rd column has "Remove" in it.

This section of code splits the files based on the first column and add the header record to each file.
:CONTENTS
for /f "delims= skip=1" %%A in (IE_MT_Monthly_MissingPayrollID_Salaried.csv) do (
echo [%%A]

FOR /f "tokens=1-2* delims=," %%A IN ("%%A") DO (

IF NOT !PREVCOMPANY! == %%A (
ECHO !Header!>> IE_MT_%%A_MissingPayrollID_S.csv
)
echo %%B,%%C>> IE_MT_%%A_MissingPayrollID_S.csv
SET PREVCOMPANY=%%A
)
If the file has "Remove" in the 3rd column I would like this line item not be added to the file.
Example File:
Company,Month,Emp,Test1,Test2,Test3,Test4,Test8
A65_08_030821_102334,08,Remove,0,,,,

Example Outcome:
Company,Month,Emp,Test1,Test2,Test3,Test4,Test8
Related categories: Perl Shell Script VBScript