質問編集履歴
2
title
CHANGED
|
File without changes
|
body
CHANGED
|
File without changes
|
1
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -29,7 +29,7 @@
|
|
|
29
29
|
|
|
30
30
|
インデックスの演算が失敗しました。配列のインデックスが null に評価されました。
|
|
31
31
|
発生場所 行:14 文字:19
|
|
32
|
-
+ %{$_.
|
|
32
|
+
+ %{$_.ID2 = $dic[ <<<< $_.ID2] ; $_} |
|
|
33
33
|
+ CategoryInfo : InvalidOperation: (:) []、RuntimeException
|
|
34
34
|
+ FullyQualifiedErrorId : NullArrayIndex
|
|
35
35
|
|
|
@@ -42,19 +42,19 @@
|
|
|
42
42
|
|
|
43
43
|
|
|
44
44
|
Get-Content C:\work\INPUT_LIST.csv | ConvertFrom-Csv -Header ID,NAME,IP,HOST,HOST2 |
|
|
45
|
-
%{ $_.
|
|
45
|
+
%{ $_.ID.PadLeft(3,"0")}
|
|
46
46
|
|
|
47
47
|
Get-Content C:\work\INPUT.csv | ConvertFrom-Csv -Header No.,day,ID1,ID2 |
|
|
48
|
-
%{ $_.
|
|
48
|
+
%{ $_.ID1.PadLeft(3,"0")} |
|
|
49
|
-
%{ $_.
|
|
49
|
+
%{ $_.ID2.PadLeft(3,"0")}
|
|
50
50
|
|
|
51
51
|
$dic = @{}
|
|
52
52
|
Get-Content C:\work\INPUT_LIST.csv | ConvertFrom-Csv -Header ID,NAME,IP,HOST,HOST2 |
|
|
53
53
|
%{$dic[$_.ID] = $_.NAME}
|
|
54
54
|
|
|
55
55
|
Get-Content C:\work\INPUT.csv | ConvertFrom-Csv -Header No.,day,ID1,ID2 |
|
|
56
|
-
%{$_.
|
|
56
|
+
%{$_.ID1 = $dic[$_.ID1] ; $_} |
|
|
57
|
-
%{$_.
|
|
57
|
+
%{$_.ID2 = $dic[$_.ID2] ; $_} |
|
|
58
58
|
Export-Csv C:\work\data\OUTPUTData.csv -encoding Default
|
|
59
59
|
```
|
|
60
60
|
|