Pfthb

I need to know if is possible to create a batch code, to read an file.txt and according the information there, access the folder path and delete file.
In my file.txt, is a result of a sql query.

my_file.txt

file_name, file_path
abcd, D:/user/desktop/teste123
efgh, D:/user/desktop/folder789

The Batch needs to read "file_name" (to know the file to delete) and file_path (to know where to delete).

Is it possible? Help me pls

Thanks.

You would run a for loop and split on the , delimeter and use each as a variable.

So as an untested example, here I will split the file entries and assign 2 tokens %%i and %%j

@echo off
for /f "tokens=1,2 delims=," %%i in (my_file.txt) do echo "%%i" "%%j"

Note that I added a double quotes to the tokens as it will possibly contain spaces.

Seeing that you want to do a delete, it will probably be something like:

@echo off
for /f "tokens=1,2 delims=," %%i in (my_file.txt) do echo del "%%j%%i"

Where you would just remove the echo to perform the actual delete.

As per your comment, to skip the first line and exclude the **rows affected line you can use:

for /f "tokens=1,2 skip=1 delims=," %i in ('more my_file.txt ^| findstr /VI /C:"rows affected"') do del "%%j%%i"

alternatively seeing that you are using more, you can exclude skip=1 and simply use +1 on the mroe command.

for /f "tokens=1,2 delims=," %i in ('more +1 my_file.txt ^| findstr /VI /C:"rows affected"') do del "%%j%%i"