$yesterday = [DateTime]::Today.AddDays(-1).ToString(“ddMMyyyy”)
$date = [DateTime]::Today.ToString(“ddMMyyyy”)
# Directory containing csv files, include *.*
$directory = “C:\FTP_Server\”
# Get the csv files
$csvFiles = Get-ChildItem $directory -Filter “*SQL – $date.csv”
# Updated 01/03/2010. Thanks to comment from Chris.
# Resolves error Method invocation failed because [System.Management.Automation.PSObject] doesn’t contain a method named ‘op_Addition’.
$content = $null
$content = @()
# Process each file
foreach($csv in $csvFiles)
{
$content += Import-Csv $csv;
}
# Write a datetime stamped csv file
#$datetime = Get-Date -Format “yyyyMMddhhmmss”;
$content | Export-Csv -Path “$directory\SQL_$date.csv” -NoTypeInformation