通过powershell拆分csv文件中的合并行

$csvData = Import-Csv -Path "data.csv"

$expandedData = foreach ($record in $csvData) {
    if ($record.Column1 -eq $null) {
        # 拆分合并行为多行
        $splitRows = $record.Column2.Split(";")
        foreach ($splitRow in $splitRows) {
            $newRecord = $record.Clone()
            $newRecord.Column2 = $splitRow
            $newRecord
        }
    } else {
        $record
    }
}

$expandedData | Export-Csv -Path "split_data.csv" -NoTypeInformation