I want to add a time and date column to a csv file using powershell

Question

I want to add time and date row at the end of each entry in the csv file. I am only able to add time and date at the end of the database not to each row

Powershell

import-csv C:\Users\system\Desktop\WindowsUpdate1.csv | 
  foreach-object {
    $row = $_
    $row | add-member NoteProperty "Time" (Get-Date -format t) 
    $row 
  }

I only get one column in regard to the date and time instead of getting it in every row.

Aside from the fact that Select-Object with calculated properties would be a better solution, as @Lee_Dailey notes, your code looks fine and should successfully add a .Time property to each input object (row). — mklement0
– mklement0, Commented Sep 18, 2019 at 9:31

Theo · Accepted Answer · 2019-09-18 09:31:21Z

2

As Lee_Dailey commented, the easiest way is to use the Select-Object cmdlet with a calculated property:

$newCsv = Import-Csv 'C:\Users\system\Desktop\WindowsUpdate1.csv' | 
    Select-Object *, @{Name = 'Time'; Expression = {(Get-Date -format s)}}

#output on screen
$newCsv

#output to new csv file
$newCsv | Export-Csv 'C:\Users\system\Desktop\WindowsUpdate2.csv' -NoTypeInformation

^{I have changed your date/time format from (Get-Date -format t) to (Get-Date -format s) in order to get a sortable date/time format because the title of the post asks for date AND time. See Standard Date and Time formats for more formats}

answered Sep 18, 2019 at 9:31

Theo

61.9k8 gold badges28 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

I want to add a time and date column to a csv file using powershell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related