Powershell將1列拆分為2列-有解無憂

我熟悉 -split 運算子以及如何拆分字串，但我無法弄清楚如何將字串拆分為一列并將其變成 2 個單獨的列

資料：

"MPN","Item_Description","Customer_Order"
"000501","BLU 60MM Slate Shale Grey (116.82 sqft/pallet - 10.62 sqft/layer)","12055"
"000501","BLU 60MM Slate Shale Grey (116.82 sqft/pallet - 10.62 sqft/layer)","12421"
"000501","BLU 60MM Slate Shale Grey (116.82 sqft/pallet - 10.62 sqft/layer)","12424"
"002243","Mini-Creta Architectural 6'' Champlain Grey (30 sqft/pallet - 6 sqft/layer)","12014"
"002243","Mini-Creta Architectural 6'' Champlain Grey (30 sqft/pallet - 6 sqft/layer)","12425"
"002243","Mini-Creta Architectural 6'' Champlain Grey (30 sqft/pallet - 6 sqft/layer)","12817"

我想弄清楚如何將“Item_Description”列中“(”和“sqft/pallet”之間的資料拆分或復制到其自己的列中。

我最大的障礙是將其拆分，然后將其作為帶有新標題的新列重新添加，如下所示：

"MPN","Item_Description","Sqft_Pallet","Customer_Order"
"000501","BLU 60MM Slate Shale Grey (116.82 sqft/pallet - 10.62 sqft/layer)","116.82","12055"
"000501","BLU 60MM Slate Shale Grey (116.82 sqft/pallet - 10.62 sqft/layer)","116.82","12421"
"000501","BLU 60MM Slate Shale Grey (116.82 sqft/pallet - 10.62 sqft/layer)","116.82","12424"
"002243","Mini-Creta Architectural 6'' Champlain Grey (30 sqft/pallet - 6 sqft/layer)","30","12014"
"002243","Mini-Creta Architectural 6'' Champlain Grey (30 sqft/pallet - 6 sqft/layer)","30","12425"
"002243","Mini-Creta Architectural 6'' Champlain Grey (30 sqft/pallet - 6 sqft/layer)","30","12817"

uj5u.com熱心網友回復：

您可以將計算屬性與Select-Object. 此示例假定Sqft_Pallet始終完全包含在括號中：

$CsvData | select MPN,
  Item_Description,
  @{l='Sqft_Pallet';e={
    # Regex is to select anything inside parentheses from Item_Description
    if ($_.Item_Description -match '\(.*\)') {$Matches.Values} 
    else {'N/A'}  ## if no full parentheses present, use N/A
  }},
  Customer_Order

輸出如下：

MPN    Item_Description                                                           Sqft_Pallet                             Customer_Order
---    ----------------                                                           -----------                             --------------
000501 BLU 60MM Slate Shale Grey (116.82 sqft/pallet - 10.62 sqft/layer)          (116.82 sqft/pallet - 10.62 sqft/layer) 12055         
000501 BLU 60MM Slate Shale Grey (116.82 sqft/pallet - 10.62 sqft/layer)          (116.82 sqft/pallet - 10.62 sqft/layer) 12421         
000501 BLU 60MM Slate Shale Grey (116.82 sqft/pallet - 10.62 sqft/layer)          (116.82 sqft/pallet - 10.62 sqft/layer) 12424         
002243 Mini-Creta Architectural 6' Champlain Grey (30 sqft/pallet - 6 sqft/layer) (30 sqft/pallet - 6 sqft/layer)         12014         
002243 Mini-Creta Architectural 6' Champlain Grey (30 sqft/pallet - 6 sqft/layer) (30 sqft/pallet - 6 sqft/layer)         12425         
002243 Mini-Creta Architectural 6' Champlain Grey (30 sqft/pallet - 6 sqft/layer) (30 sqft/pallet - 6 sqft/layer)         12817         
002243 Mini-Creta Architectural 6' Champlain Grey 30 sqft/pal                     N/A                                     12817

轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/329520.html

標籤：电源外壳文件分裂

上一篇：如何使用PHP陣列創建CSV檔案？

下一篇：Jmeter-如何在登錄后從下拉串列中獲取最新選定值的資料？