Solved

search for file and create list in CSV using command prompt

Posted on 2010-08-19
6
287 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
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

760 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now