powershell - 从文本文件创建CSV并定义字段

Question

我想要一个文本文件，文本之间有空格，并使用定义的字段创建CSV文件。我已经搜索了一下，但是还没有找到一种方法。我看到了很多处理定义良好的字段delim的示例，但没有一个如下所示的任意字段。

输入文件:

   1001 Mitch, Bucanon                          NO    NO    Baywatch, TV
   1002 SPARE SPARE SPARE                       NO    NO    SPARE
   1003 Sparrow, Jack                           NO    YES   Pirates, carrb 2

所需的输出:

"1001","Mitch, Bucanon","NO","NO","Baywatch,TV"
"1002","SPARE SPARE SPARE","NO","NO","SPARE"
"1003","Sparrow, Jack","NO","YES","Pirates, Carrib 2"

Answer 1

它是固定宽度，所以您需要位置。因此，这是一个示例:

$arr = @()
$arr += "1001 Mitch, Bucanon                          NO    NO    Baywatch, TV"
$arr += "1002 SPARE SPARE SPARE                       NO    NO    SPARE"
$arr += "1003 Sparrow, Jack                           NO    YES   Pirates, carrb 2"

foreach($item in $arr)
{
    $code = $item.SubString(0,4);
    $name = $item.SubString(5, 40).Trim();
    $bin1 = $item.SubString(45, 6).Trim();
    $bin2 = $item.SubString(51, 6).Trim();
    $column5 = $item.SubString(57).Trim();
    write-host ($code + ",""" + $name.Trim() + """,""" + $bin1 + """,""" + $bin2 + """,""" + $column5 + """")
}