Windows batch file to list the file from one folder into csv / txt file

Question

I need a .bat and .sh script to list the all the *.xml files from source folder into one csv/txt file and copy csv/txt file into destination folder.

@ECHO OFF
NET USE X: /DELETE
NET USE X: \\SERVER\TEST
setlocal ENABLEDELAYEDEXPANSION
echo. > X:\XML_Response\xml_file_list.csv
set searchid="%<OrderNumber>"
for /f %%a in ('findstr /i /m %searchid% X:\XML_Response\*.xml') do (
  echo %%a >> X:\XML_Response\xml_file_list.csv
)
NET USE X: /DELETE

Above code give me list of files with path. I just want to have filenames.

X:\XML_Response\SO2001.xml 
X:\XML_Response\SO2002.xml

I need only

SO2001.xml
SO2002.xml

Can anyone help

Possible duplicate of [How to split the filename from a full path in batch?](https://stackoverflow.com/questions/9252980/how-to-split-the-filename-from-a-full-path-in-batch) — Sunil, Dec 18 '17 at 11:28
@Sunil, Thanks for the link. I use %%nxa for eco and it worked. — Abhijit, Dec 18 '17 at 11:41

score 0 · Accepted Answer · answered Dec 18 '17 at 13:02

0

You could shorten your script and still output what you asked for.

@PushD \\SERVER\TEST\XML_Response
@FindStr/MILC:"<OrderNumber>" *.xml>xml_file_list.csv

answered Dec 18 '17 at 13:02

Compo

36,585
5
27
39

thanks. Could you please suggest what should be the script if we don't need to search for string , just find and list all the xml files from the folder. – Abhijit Jan 06 '18 at 09:43
After almost three weeks, the least you could have done was to mark the answer as accepted, not to ask a completely different question. Change line `2` to `@Dir /B/A-D-L *.xml>"xml_file_list.csv"`. – Compo Jan 06 '18 at 11:43

Windows batch file to list the file from one folder into csv / txt file

1 Answers1