powershell csv gists

add_line_number.ps1

Import-CSV SomeFile.csv | Select *,LINENUMBER | ForEach-Object -Begin { $Line = 1 } { 
    $_.LineNumber = $Line++
    $_ 
} | Export-CSV SomeFile.csv

add_running_total.ps1

# for column "FI_NR",

Import-CSV test.csv -Delimiter ";" | Select *,INCREMENTAL_SUM | ForEach-Object -Begin { $Increment = 0 } { 
    $Increment += $_.FI_NR
    $_.INCREMENTAL_SUM  = $Increment
    $_ 
} | Export-CSV SomeFile.csv

sort_csv_file_by_column.ps1

# file will be sorted for column username

Import-Csv C:\fso\testusers.csv.old | sort username -Descending | Export-Csv -Path c:\fso\testusers.csv -NoTypeInformation