Fill in a column in a CSV file using POWERSHELL V2

Question 1

i have a CSV file :

COL1;COL2;COL3;COL4
1;1;;4
6;9;;0
9;8;;4

1

2

3

4

5

COL1;COL2;COL3;COL4

1;1;;4

6;9;;0

9;8;;4

How do i fill in COL3 with a default value X?

so the result would be :

COL1;COL2;COL3;COL4
1;1;x;4
6;9;x;0
9;8;x;4

1

2

3

4

5

COL1;COL2;COL3;COL4

1;1;x;4

6;9;x;0

9;8;x;4

How can i achieve this using Powershell V2 or even ultra edit or Notepad++

Thanks

Question 2

Import-CSV -Path "input.csv" -Delimiter ';' | `
ForEach-Object { $_.COL3 = "x"; return $_ } | `
Export-CSV -Path "output.csv" -Delimiter ';' -NoTypeInformation

1

2

3

4

Import-CSV -Path "input.csv" -Delimiter ';' | `

ForEach-Object { $_.COL3 = "x"; return $_ } | `

Export-CSV -Path "output.csv" -Delimiter ';' -NoTypeInformation

Fill in a column in a CSV file using POWERSHELL V2

Question:

Answer:

Source:

Fill in a column in a CSV file using POWERSHELL V2 by stackoverflow.com licensed under CC BY-SA | With most appropriate answer!

Leave a Reply Cancel reply