[CmdletBinding()] param( [Parameter(Mandatory = $true)] [string]$Path, [string[]]$Columns = @(), [string]$OutFile = '', [switch]$Force ) $ErrorActionPreference = 'Stop' if (-not (Test-Path -LiteralPath $Path -PathType Leaf)) { throw "Файл не найден: $Path" } $resolved = (Resolve-Path -LiteralPath $Path).Path if ([string]::IsNullOrWhiteSpace($OutFile)) { $directory = [System.IO.Path]::GetDirectoryName($resolved) $stem = [System.IO.Path]::GetFileNameWithoutExtension($resolved) $OutFile = Join-Path $directory ($stem + '_masked.csv') } if ([System.IO.Path]::IsPathRooted($OutFile)) { $outFull = [System.IO.Path]::GetFullPath($OutFile) } else { $outFull = [System.IO.Path]::GetFullPath((Join-Path (Get-Location).Path $OutFile)) } if ($resolved -eq $outFull) { throw "Выходной файл не должен совпадать с исходным" } if (Test-Path -LiteralPath $outFull) { if (-not $Force) { throw "Файл уже существует: $outFull. Добавьте -Force" } } $rows = @(Import-Csv -LiteralPath $resolved) if ($rows.Count -eq 0) { throw "В CSV нет строк данных" } $headers = @($rows[0].PSObject.Properties.Name) $requested = @() foreach ($entry in $Columns) { foreach ($part in ($entry -split ',')) { $trimmed = $part.Trim() if ($trimmed.Length -gt 0) { $requested += $trimmed } } } $Columns = @($requested) if ($Columns.Count -eq 0) { $Columns = @($headers | Where-Object { $_ -match '(?i)email|mail|phone|tel|name|address|city' }) } if ($Columns.Count -eq 0) { throw "Не удалось определить колонки. Укажите их через -Columns" } foreach ($column in $Columns) { if (-not ($headers -contains $column)) { throw "Колонка не найдена: $column" } } function Get-MaskedValue { param([string]$Column, [string]$Value) if ([string]::IsNullOrEmpty($Value)) { return $Value } switch -Regex ($Column) { '(?i)email|mail' { $match = [regex]::Match($Value, '^([^@])[^@]*(@.*)$') if ($match.Success) { return $match.Groups[1].Value + '***' + $match.Groups[2].Value } return '***' } '(?i)phone|tel' { $match = [regex]::Match($Value, '(\d{2})\D*$') if ($match.Success) { return '***-**-' + $match.Groups[1].Value } return '***' } '(?i)name' { return $Value.Substring(0, 1) + '***' } '(?i)address|city' { return $Value.Substring(0, 1) + '***' } default { return '***' } } } $masked = 0 foreach ($row in $rows) { foreach ($column in $Columns) { $value = [string]$row.$column $newValue = Get-MaskedValue -Column $column -Value $value if ($newValue -ne $value) { $masked += 1 } $row.$column = $newValue } } $rows | Export-Csv -LiteralPath $outFull -NoTypeInformation -Encoding UTF8 Write-Host "Строк: $($rows.Count)" Write-Host "Колонок: $($Columns.Count)" Write-Host "Замаскировано значений: $masked" Write-Host "Результат: $outFull"