1
2
3
4
5
6
7
8
9
| $csv = Import-Csv -LiteralPath "file.csv" -Encoding UTF8 -Delimiter ";"
$csv = $csv | Select-Object *, @{
label='Mois'
expression={[datetime]::ParseExact($_."date de naissance", "dd/MM/yyyy", [Globalization.CultureInfo]::InvariantCulture).ToString("yyyy-MM")}
}
$csv | Where-Object {$_.code -match "^\d+$"} | Export-Csv -LiteralPath "numerique.csv" -Encoding UTF8 -Delimiter ";" -NoTypeInformation
$csv | Where-Object {$_.code -notmatch "^\d+$" -and $_.code -notmatch "^[a-z0-9]+$"} | Export-Csv -LiteralPath "Alphanumerique.csv" -Encoding UTF8 -Delimiter ";" -NoTypeInformation |
