Friday 12 September 2014

Extract_FileNames_FromFolder

1)Open txt file

2)Copy and paste the below contents into the text file.

for %%G in (*.sql) do echo %%G >>log.txt
pause

3)Save the txt file with the name as you wish ends with .bat extension[Ex: ExtractFilename.bat] and change the Save as Type to All Files.

4)Put this batch file in the folder you wish to extract the filenames resides in that folder.

5)Double click the batch file to get all the file names(under a folder) in the log.txt file