Trim CSV data

input.csv

TrimCSV.ps1

# Specify input and output files
$InputCSVFile  = '.\input.csv'
$OutputCSVFile = '.\output.csv'


# Import data from CSV
$CSVData = Import-Csv -Path $InputCSVFile

# Run trim() (remove leading and trailing whitespace) on all property values
$CSVTrimmedData = $CSVData | Foreach-Object {
    
    # Foreach property
    $_.PSObject.Properties | Foreach-Object {
        
        # Trim the value (remove whitespace)
        $_.Value = $_.Value.Trim()
    }

    # Output the object
    Write-Output $_
} 

# Export trimmed data to CSV
$CSVTrimmedData | Export-Csv -Path $OutputCSVFile -NoTypeInformation