Page 1 of 1

export to txt file using dir

Posted: 29 Aug 2018 11:28
by abenitez77
I am using the command below to export to a txt file, but it missed all files with periods in part of the file name (i.e. "myfilename 2.21.2007 east_coast - (blue).xlsm" )

dir "\\USATL02ERAS40\Images\Walgreens\VSF_Ingestion\Vendor Submission XLSB All 050218\*.xls*" /A /B /S > XLSB_Walgreens_2017_3.txt

How can I capture all the files that end with the extension ( xls, xlsm, xlsb, xlsx ) and export it to a text file?

Re: export to txt file using dir

Posted: 29 Aug 2018 12:33
by abenitez77
nevermind...that was not my issue. It was importing files with multiple periods... I have to go back and see what is going on.