Powershell how to add data in the csv file to one column

Question

I have a csv file with a few columns. For example

col1;col2;col3;col4  
text1;text2;text3;text4  
text5;text6;text7;text8  
text9;text10;text11;text12

I want to add text to column col3, like this:

col1;col2;col3;col4  
text1;text2;append\text3;text4  
text5;text6;append\text7;text8  
text9;text10;append\text11;text12

So question is:
How to do this?

(I'm stuck whit that how I add data to each column in col3.)

Will Webb · Accepted Answer · 2017-09-13 14:54:04Z

3

Give this a whirl:

Import-Csv -Delim ';' cols.csv | 
    ForEach-Object {$_.col3 = "prepend\$($_.col3)";$_} |
    Export-Csv cols2.csv -Delim ';' -NoTypeInformation

Use the -NoTypeInformation parameter to avoid this comment getting put at the top of your CSV:

#TYPE System.Management.Automation.PSCustomObject

However, if you don't mind the comment then you can leave off the -NoTypeInformation parameter.

edited Sep 13, 2017 at 14:54

Will Webb

8258 silver badges20 bronze badges

answered Mar 23, 2011 at 6:46

Keith Hill

204k44 gold badges370 silver badges377 bronze badges

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

1 Comment

not2qubit Over a year ago

The -NoTypeInformation is now default behavior.

Will Webb · Accepted Answer · 2017-09-15 10:43:16Z

3

You probably know how to read/write data. To change the data, send them to Foreach-Object, alter the data and pass the object further to Export-Csv.

Import-Csv d:\temp\so\csv1.txt  -Delimiter ';' | 
   ForEach-Object { $_.col3 = 'append\' +$_.col3; $_ } | 
   Export-Csv d:\temp\so\csv2.txt -Delimiter ';'

edited Sep 15, 2017 at 10:43

Will Webb

8258 silver badges20 bronze badges

answered Mar 23, 2011 at 6:44

stej

29.5k11 gold badges76 silver badges106 bronze badges

2 Comments

JanS Over a year ago

Thank you very much! I have even tried this code before but there seems to be that I have few code format errors...Need to study more. Problem solved!

stej Over a year ago

No problem :) I see that we both with Keith added the same answer. Funny ;)

Collectives™ on Stack Overflow

Powershell how to add data in the csv file to one column

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related