#PowershellBasics: Get a list of files from a directory.

4

October 21, 2021 by Kenneth Fisher

I’ve got a project I’m working on at the moment and it includes a number of elements from my recent Powershell Basics posts. If it works out I’ll share later but feel free to guess. 😀 In the mean time the next element I needed was a list of files in given directory.

$Path = "C:\temp\"
get-childitem -path $Path -filter *.csv

Directory: C:\temp
Mode LastWriteTime Length Name
—- ————- —— —-
-a—- 6/27/2021 11:26 AM 66 Employee.csv
-a—- 7/12/2021 5:15 PM 245609 comments.csv
-a—- 7/30/2021 7:04 PM 62443 test1.csv

I’m using the command get-childitem but I could just have easily used it’s standard alias dir. It has a number of parameters but here I’m passing in the -path to tell it where to look and I’m using the -filter parameter to just get the CSV files. I could just as easily using -include to get the CSVs, or use -exclude to remove the files I’m not interested in. Last but not least, in my case I only want to get the file names so I’m going to include the -name parameter.

$Path = "C:\temp\"
get-childitem -path $Path -filter *.csv -name

Employee.csv
comments.csv
test1.csv

Note: With the -name parameter I don’t get a header either, just the list of file names. Sadly there is no way to sort here, so I’ll have to figure that out next.

4 thoughts on “#PowershellBasics: Get a list of files from a directory.

  1. David James says:

    I had to do something similar recently to look for zip files in a dir and subdirs so my SQL was thus:-

    set @OuterSQL = ‘@echo off & for /f “tokens=*” %a in (”dir E:\SQLData\’ + @MyDirName + ‘\*.zip /s /b”) do echo %~fa %~ta’

    INSERT INTO #DirsTmp ([Filename])
    exec xp_cmdshell @OuterSQL

  2. Chad Baldwin says:

    Great post! I love these basics posts, I’ve been wanting to start a series myself.

    I feel it’s also worth mentioning that:

    gci -Filter *.csv

    Is very different from:

    gci *.csv

    I learned this one the hard way while working on a project. Using the -Filter parameter is much more efficient. When you don’t use -Filter, it defaults to using -Path, which also accepts wildcards. So you’re technically running

    gci -Path *.csv

    Even though they return the same results…using -Filter will be much faster. For years, I used “gci *.csv” because it was quicker to type, but once I learned how slow it was, I always make sure to type -Filter now.

  3. […] my last post I grabbed a file list but I really need it sorted alphabetically. Now, I’ve been a DBA my entire career and one of […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,614 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: