Solved

search for file and create list in CSV using command prompt

Posted on 2010-08-19
6
292 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

 
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

Don't Cry: How Liquid Web is Ensuring Security

WannaCry is just the start. Read how Liquid Web is protecting itself and its customers against new threats.

Question has a verified solution.

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

When asking a question in a forum or creating documentation, screenshots are vital tools that can convey a lot more information and save you and your reader a lot of time
Windows 10 Creator Update has just been released and I have it working very well on my laptop. Read below for issues, fixes and ideas.
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

728 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