Fill in a column in a CSV file using POWERSHELL V2

Question

i have a CSV file :

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

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

Thanks

Use my FOSS tool CSVfix at code.google.com/p/csvfix - makes doing stuff like this a breeze. — anon
– anon, Commented Jul 28, 2010 at 9:22
Thanks, i m trying it, but i m dealing with special CSV files, with double pipe delimiters || and with more than 500 000 lines.. So i tried this command with your tool : echo -sep '||' myfile.csv ... but it doesnt work, it just keeps hanging (file too big?) — guigui42
– guigui42, Commented Jul 28, 2010 at 9:36
CSV as its name suggests is COMMA separated - what you have is not CSV. However, CSVfix can deal with other separators, but not multiple separator characters. If that's your format (why??) why didn't you use it in your example above? Also, you probably want to use double quotes to quote pipe symbols. — anon
– anon, Commented Jul 28, 2010 at 9:58
Actually, the C in CSV stands for Character, not Comma. So what the OP has is CSV, and your tool only deals with the most common format (using commas as the delimeter). — JohnL
– JohnL, Commented Aug 11, 2010 at 15:05

George Howarth · Accepted Answer · 2010-07-28 10:57:03Z

7

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

answered Jul 28, 2010 at 10:57

George Howarth

2,92321 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Keith Hill Over a year ago

Instead of ; return $_, ; $_ is sufficient.

George Howarth Over a year ago

I know, but it's a better indication of what I mean.

x0n Over a year ago

yes, but it's generally confusing to people new to the language. as a guideline, consider using return only without arguments, and only to exit early. frankly, I think the keyword should have been designed like that in the first place.functions/scriptblocks early ony.

Enrico Over a year ago

I do not understand the return $_, why is this required?

Collectives™ on Stack Overflow

Fill in a column in a CSV file using POWERSHELL V2

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related