Using the values from a CSV file

• OleHank

  SSChasing Mays

  Points: 654

  More actions

  December 6, 2019 at 10:03 am

  #3705281

  Hi,

  I want to load a log so that I can see which bat file failed, and restart from that point.  I'm struggling a bit with this, can anyone point me in the right direction? So far I have got:

  $csv = Import-Csv E:\Backup\Schdule_log.csv

  $csv

  $Failed  = $csv.Batfile | Where-Object {$csv.Result -eq 'Failed'}

  But $Failed is  returning all of the files, so my where clause must be wrong

   

  Thanks

   

  • This topic was modified 4 years, 4 months ago by  OleHank.
  • This topic was modified 4 years, 4 months ago by  OleHank.

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  December 7, 2019 at 10:10 am

  #3705642

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• frederico_fonseca

  SSCoach

  Points: 16014

  More actions

  December 7, 2019 at 10:44 am

  #3705650

  without having sample data its hard to tell.

   

  but try

  $Failed  = $csv | Where-Object {$csv.Result -eq 'Failed'}|select -property Batfile