Solved

search for file and create list in CSV using command prompt

Posted on 2010-08-19
6
291 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
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 
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

Manage your data center from practically anywhere

The KN8164V features HD resolution of 1920 x 1200, FIPS 140-2 with level 1 security standards and virtual media transmissions at twice the speed. Built for reliability, the KN series provides local console and remote over IP access, ensuring 24/7 availability to all servers.

Question has a verified solution.

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

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 …
There are many software programs on offer that will claim to magically speed up your computer. The best advice I can give you is to avoid them like the plague, because they will often cause far more problems than they solve. Try some of these "do it…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

734 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