Solved

search for file and create list in CSV using command prompt

Posted on 2010-08-19
6
289 Views
Last Modified: 2012-05-10
How do I find all the files with a "9" in the filename in a folder and its sub-folders, with executing a command from cmd and then export that to a csv file as i tried using > c:\filelist.csv but this doesn't put a comma after each filename in the list.

The command i tried is:

dir /a-d /b C:\*_9_*.txt>filelist.csv
0
Comment
Question by:mmatharu
  • 3
  • 3
6 Comments
 
LVL 11

Accepted Solution

by:
Coast-IT earned 500 total points
ID: 33474861
export it to txt, open excel, and excl will ask you what to do with it, all you need to do is specify your required spacing.

Worked for me recently.

I would use c:\dir /a /s *9* > c:\fileswith9.txt

then import it into excel as above.
0
 

Author Comment

by:mmatharu
ID: 33474975
Hi,

Thanks for the quick response, but that file will then be used by an automated process so I will not have the chance to open and edit the file.
0
 

Author Comment

by:mmatharu
ID: 33475180
if i execute the dir command above "c:\dir /a /s *9* > c:\fileswith9.txt" it gives me the following out put, I just want a list of the filenames of the file with a specific number in this case i was using 9.

 Volume in drive E has no label.
 Volume Serial Number is 0C76-DFCA

 Directory of E:\folder1\folder2\datafolder

08/19/2010  04:07 AM    <DIR>          .
08/19/2010  04:07 AM    <DIR>          ..
08/19/2010  07:47 AM    <DIR>          extract
08/19/2010  07:45 AM    <DIR>          full_extract
08/19/2010  07:48 AM    <DIR>          mapping
07/01/2010  11:02 AM    <DIR>          persist
08/19/2010  04:07 AM             2,762 policy_type.ds
08/19/2010  07:52 AM    <DIR>          staging
05/21/2010  10:00 AM             4,785 ZNNA_3.DS
05/21/2010  10:00 AM             7,669 ZUCO_3.DS
05/21/2010  10:00 AM             8,827 ZUMA_3.DS
05/21/2010  10:00 AM             7,387 ZUSF_3.DS
               5 File(s)         31,430 bytes

 Directory of E:\folder1\folder2\datafolder\extract

08/19/2010  07:47 AM    <DIR>          .
08/19/2010  07:47 AM    <DIR>          ..
07/09/2010  10:52 AM             3,286 Currency_0_Extract.ds
08/03/2010  09:59 AM             5,946 ICDCREP_0_Extract.ds
08/19/2010  06:41 AM             3,470 ICDCREP_30_Extract.ds
08/19/2010  07:45 AM             3,470 ICDCREP_32_Extract.ds
08/17/2010  09:53 AM             3,472 ICDCREP_9_Extract.ds
08/10/2010  09:35 AM             3,736 Reporting_Structure_5_Extract.ds
08/19/2010  07:39 AM             3,144 ZACJDF00_34_Extract.ds
07/20/2010  10:47 AM             5,612 ZACJDF00_5_Extract.ds
08/03/2010  10:01 AM             5,860 ZHKTDF00_0_Extract.ds
08/19/2010  06:38 AM             3,378 ZHKTDF00_30_Extract.ds
08/19/2010  07:42 AM             3,376 ZHKTDF00_32_Extract.ds
0
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 
LVL 11

Expert Comment

by:Coast-IT
ID: 33475523
You can use dir /a/s/b *9*.* > c:\9.txt

I have just done this and got the following output - it will always publish the path along with the file I think

C:\9.txt
C:\DELL\drivers\R190031
C:\DELL\drivers\R190974
C:\DELL\drivers\R191024
C:\DELL\drivers\R182522\All\915.cat
C:\DELL\drivers\R182522\All\915.inf
C:\DELL\drivers\R182522\All\915M.cat
C:\DELL\drivers\R190031\HDAQFE\win2k3\us\kb901105.exe
C:\DELL\drivers\R190031\WDM\92HDM4-1.INI
C:\DELL\drivers\R190031\WDM\92HDM4-2.INI
C:\DELL\drivers\R190031\WDM\92HDM4-3.INI
C:\DELL\drivers\R190031\WDM\92HDM4-4.INI
C:\DELL\drivers\R190031\WDM\92HDM4-5.INI
C:\DELL\drivers\R190031\WDM\DellHDM9.bld
C:\DELL\drivers\R194581\Drivers\w29n50.sys
C:\DELL\drivers\R194581\Drivers\w29n51.cat
C:\DELL\drivers\R194581\Drivers\w29n51.inf
C:\DELL\drivers\R194581\Drivers\w29n51.sys
C:\DELL\drivers\R197513\BTW3208\Win32\0x0409.ini
C:\DELL\drivers\R197513\BTW3208\Win32\0x0419.ini
C:\DELL\drivers\R197513\BTW3208\Win32\1029.mst
C:\DELL\drivers\R197513\BTW3208\Win32\1049.mst
C:\DELL\drivers\R197513\BTW3208\Win32\Lang\1029



any better?
0
 

Author Comment

by:mmatharu
ID: 33476378
Yes thanks thats worked but do you know how i can output the list like this:

C:\9.txt,C:\DELL\drivers\R190031,C:\DELL\drivers\R190974,C:\DELL\drivers\R191024,C:\DELL\drivers\R182522\All\915.cat,C:\DELL\drivers\R182522\All\915.inf,C:\DELL\drivers\R182522\All\915M.cat


with a comma after each filename
0
 
LVL 11

Expert Comment

by:Coast-IT
ID: 33540081
No idea
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question