teratail header banner
teratail header banner
質問するログイン新規登録

回答編集履歴

3

修正:全角空白記述が半角空白になっていた。

2017/03/03 04:20

投稿

Y.H.
Y.H.

スコア7918

answer CHANGED
@@ -4,11 +4,11 @@
4
4
 
5
5
  普通にif文かけますよ。
6
6
 
7
- # `"NULL,hoge,2"`⇒`" ,hoge,2"`
7
+ # `"NULL,hoge,2"`⇒`" ,hoge,2"`
8
8
  ```
9
9
  Get-Content "[ファイルパス&ファイル名.csv]" | % {
10
10
  if (($_.Split(",")[0] -eq 'NULL') -and ($_.Split(",")[2] -eq '2')){
11
- " " + "," +
11
+ " " + "," +
12
12
  $_.Split(",")[1] + "," +
13
13
  $_.Split(",")[2] + ","
14
14
  } else {
@@ -19,11 +19,11 @@
19
19
  } | Out-File -Encoding default [ファイルパス&ファイル名.csv]
20
20
  ```
21
21
 
22
- # `",hoge,2"`⇒`" ,hoge,2"`
22
+ # `",hoge,2"`⇒`" ,hoge,2"`
23
23
  ```
24
24
  Get-Content "[ファイルパス&ファイル名.csv]" | % {
25
25
  if (($_.Split(",")[0] -eq '') -and ($_.Split(",")[2] -eq '2')){
26
- " " + "," +
26
+ " " + "," +
27
27
  $_.Split(",")[1] + "," +
28
28
  $_.Split(",")[2] + ","
29
29
  } else {

2

引用範囲修正

2017/03/03 04:20

投稿

Y.H.
Y.H.

スコア7918

answer CHANGED
@@ -1,4 +1,5 @@
1
1
  > if文のサイト等で中身を見ましたが分かりませんでした。
2
+
2
3
  どこまでわかって何がわからなかったのでしょうか?
3
4
 
4
5
  普通にif文かけますよ。

1

回答追記

2017/03/03 04:18

投稿

Y.H.
Y.H.

スコア7918

answer CHANGED
@@ -31,4 +31,31 @@
31
31
  $_.Split(",")[2] + ","
32
32
  }
33
33
  } | Out-File -Encoding default [ファイルパス&ファイル名.csv]
34
- ```
34
+ ```
35
+
36
+ ----
37
+
38
+ # テスト結果
39
+
40
+ ```
41
+ PS C:\tmep> (',hoge,2', 'NULL,hoge,2', 'fuga,hoge,2')|%{
42
+ >> if (($_.Split(",")[0] -eq 'NULL') -and ($_.Split(",")[2] -eq '2')){
43
+ >> " " + "," +
44
+ >> $_.Split(",")[1] + "," +
45
+ >> $_.Split(",")[2] + ","
46
+ >> } elseif (($_.Split(",")[0] -eq '') -and ($_.Split(",")[2] -eq '2')){
47
+ >> " " + "," +
48
+ >> $_.Split(",")[1] + "," +
49
+ >> $_.Split(",")[2] + ","
50
+ >> } else {
51
+ >> $_.Split(",")[0] + "," +
52
+ >> $_.Split(",")[1] + "," +
53
+ >> $_.Split(",")[2] + ","
54
+ >> }
55
+ >> }
56
+ >>
57
+ ```
58
+
59
+ >  ,hoge,2,
60
+ >  ,hoge,2,
61
+ > fuga,hoge,2,