Powershell Read CSV to get File existence status

Question

Powershell Read CSV to get File existence status

Joel Heideman 136

I have a script that woks brilliantly to delete files from a CSV. I am struggling to create a script to read the same file to get status that the file no longer exists. Any help? :)

Delete script:

Import-Csv c:\files.csv | Foreach-Object{Remove-Item -LiteralPath $_.FullName -Force}

Validate script

Import-Csv c:\files.csv | get-childitem | where {!$.PSIsContainer} | select-object FullName, LastWriteTime, Length | export-csv -notypeinformation -path verifiedfiles.csv | % {$_.Replace('"','')}

Answer accepted by question author

0 additional answers

Your answer

Answer 1

Rich Matheisen 48,026

You aren't very clear about what you want to know. I think what you want is a list files that should have been deleted but were not. If that's the case, this should do it:

Import-Csv c:\FilesToBeDeleted.csv | 
    ForEach-Object{
        if ( Test-Path -LiteralPath $_.FullName ){	# is the file still present?
            $_ | Select-Object FullName
        } 
    } | Export-Csv -notypeinformation -path FilesThatShouldHaveBeenDeleted.csv

EDIT: Changed "$<underbar>.FullName" to "$_ | Select-Object FullName"

Joel Heideman 136 Reputation points

2024-02-20T17:26:59.0733333+00:00

Thank you so much. Yeah, I just want to now check the same list for its existence as some were not deleted due to ACL etc.
Joel Heideman 136 Reputation points

2024-02-20T18:04:30.72+00:00

Script giving this output - by the way, it is an honor to have the immortal RichM assist. You're a legend. :)
Rich Matheisen 48,026 Reputation points

2024-02-20T19:20:48.4033333+00:00

Sorry. The "<underbar>.FullName" should have been "$_ | Select-Object FullName". I corrected the code in my original answer.
Joel Heideman 136 Reputation points

2024-02-20T20:46:19.6733333+00:00

Thank you Rich - code is poetry. I am a poet with English, but not PS.

Rich Matheisen 48,026

You can actually write poetry in Perl! PowerShell, not so much.

#!/usr/bin/perl 

APPEAL: 

listen (please, please); 
    open yourself, wide; 
    join (you, me), 
connect (us,together),

tell me. 

do something if distressed; 
    @dawn, dance; 
    @evening, sing; 
    read (books,$poems,stories) until peaceful; 
    study if able; 

    write me if-you-please; 

sort your feelings, reset goals, seek (friends, family, anyone); 
    do*not*die (like this) 
    if sin abounds; 

keys (hidden), open (locks, doors), tell secrets; 
do not, I-beg-you, close them, yet. 
                     accept (yourself, changes), 
                     bind (grief, despair); 

require truth, goodness if-you-will, each moment; 

select (always), length(of-days) 

# listen (a perl poem) # Sharon Hopkins 
# rev. June 19, 1995 docstore.mik.ua/orelly/perl/prog3/ch27_02.htm

Share via

Powershell Read CSV to get File existence status

0 additional answers

Your answer