Page 1 of 1
How to extract many file names in various folders into excel
Posted: 04 Mar 2009 01:27
by benben007
Hello,
I have many PDF files which i would like to build a list of into excel...
Or in otherwords
I want to make a list in excel of all the file names i have in certain folders, which sometimes is several hundred.
Please advise how to do this....
Thank You
Re: How to extract many file names in various folders into excel
Posted: 04 Mar 2009 01:58
by zer0
I'm not 100% it is what you want, but you can search for "*.pdf", which will give you a list of PDFs you have, select all of them and apply the line of code below to have list of those filenames copied to clipboard, which then you can import into Excel.
Code: Select all
copytext report("{Name}<crlf>", 1);
Re: How to extract many file names in various folders into excel
Posted: 04 Mar 2009 05:03
by serendipity
Hi and Welcome to XYplorer;
If I understood correctly, you want to write a list of PDF files in the current folder to an excel file, right? If so this should work:
Code: Select all
//Filter PDF files
filter *.pdf;
//Select all files
sel a;
//Copy all selected files' names to clipboard
#102;
//Write clipboard to a file called PDFs.csv
writefile ("PDFs.csv", <clipboard>, o);
//Remove filter
filter;
//Goto the new file
goto "PDFs.csv";
If you want to create more complex lists use report command to do so.
Read about it.
Re: How to extract many file names in various folders into excel
Posted: 30 Apr 2009 08:46
by admin
You don't need a script to do this. Use the Report tab on the Info Panel, Current Folder / Extended INfo to CSV / To Clipboard (or To File). You will get a list like this (below are 4 long lines, wrapped by the forum software):
Code: Select all
Name;DOS Name;Type;Location;Size;Space Used;Clusters;Created;Modified;Accessed;Attributes;File Version;Description;Copyright;Character Set;Comments;Company Name;Internal Name;Language;Legal Trademarks;OLESelfRegister;Original Filename;Product Name;Product Version;Extra Info;Fixed Type;Fixed File Version;Fixed Product Version;Fixed File Flags;Fixed Target OS
affiliate.htm;AFFILI~1.HTM;Firefox Document;D:\www\xyplorer.com\code\;7251;8192;2;23.02.2006 13:55:03;03.01.2009 17:05:18;30.04.2009 08:43:29;----A----I-;;;;;;;;;;;;;;;;;;;
contact.htm;CONTACT.HTM;Firefox Document;D:\www\xyplorer.com\code\;4829;8192;2;25.11.2005 19:51:15;25.03.2009 14:08:24;30.04.2009 08:43:29;----A----I-;;;;;;;;;;;;;;;;;;;
donation.htm;DONATION.HTM;Firefox Document;D:\www\xyplorer.com\code\;7458;8192;2;25.11.2005 19:51:15;03.02.2009 15:18:45;30.04.2009 08:43:29;----A----I-;;;;;;;;;;;;;;;;;;;