CSV file editing using PowerShell

Question

I need to do below using PowerShell scripting.

I have the below data in CSV file. I need to append another prefix to the name according to the subject supplied

Name,Subject,Roll,Div
Mark,Agri,3,Div1,
Tom,CS,6,Div3,
Alex,Aero,9,Div6

Suppose i am supplied the subject as Agri, the name should have prefix as P-. So the same CSV file will be saved and have below content

Name,Subject,Roll,Div
P-Mark,Agri,3,Div1,
Tom,CS,6,Div3,
Alex,Aero,9,Div6

Here's what I have so far:

(Import-Csv E:\Test.csv -Delimiter ',') | ForEach-Object{

    if($_.Subject -match "Agri" )
    {
      $_ = "P-" + "$_";

    }
    else
    {
     $_ = "F-" + "$_";

    }

} | Export-Csv E:\Test.csv -Delimiter ','

Can we see what you've tried so far?

crush
– crush

2013-12-27 22:01:31 +00:00
Commented Dec 27, 2013 at 22:01 — crush
– crush, Commented Dec 27, 2013 at 22:01

crush · Accepted Answer · 2013-12-27 22:39:23Z

6

I wasn't able to pipe this together - might just be ignorance on my part about powershell syntax. I was able to do it with the following using two lines:

($csv = Import-Csv E:\Test.csv -Delimiter ',') | ForEach {
    if ($_.Subject -match "Agri") {
        $_.Name = 'P-' + $_.Name
    } else {
        $_.Name = 'F-' + $_.Name
    }

}
$csv | Export-Csv E:\Test.csv -Delimiter ',' -NoType

Notice:

$_ = "P-" + $_;

Becomes

$_.Name = "P-" + $_.Name;

edited Dec 27, 2013 at 22:39

answered Dec 27, 2013 at 22:10

crush

17.1k10 gold badges65 silver badges104 bronze badges

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

5 Comments

usr021986 Over a year ago

I am getting blank file as out put. I need the same file to be modified as out put. Am I missing something?

crush Over a year ago

Let me try testing it with files. I tested it keeping everything in powershell and using ConvertFrom-Csv.

crush Over a year ago

I'm having trouble piping this all into a single line. If I store the $csv into a variable first, and then do $csv | Export-Csv E:\Test.csv -Delimiter ',' then it works fine...

crush Over a year ago

Updated with two line answer

Zaren Wienclaw Over a year ago

This deletes what's on the file when exported.

hoss · Accepted Answer · 2015-07-26 00:32:53Z

2

It seems to me the use of paren's in the following clause.

($csv = Import-Csv E:\Test.csv -Delimiter ',')

will assign to $csv the output of Import-Csv PRIOR to the ForEach processing and therefore the ForEach effects are completely lost. Not sure what you purpose is in using those paren's.

edited Jul 26, 2015 at 0:32

hoss

2,4683 gold badges29 silver badges43 bronze badges

answered Jul 25, 2015 at 23:43

Greg

211 bronze badge

Collectives™ on Stack Overflow

CSV file editing using PowerShell

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related