Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

search for file and create list in CSV using command prompt

Posted on 2010-08-19
6
Medium Priority
?
294 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 2000 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
By default Outlook 2016 displays only one time zone in the Calendar. The following article explains how to display two time zones in one calendar view.
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). …
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

597 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