Importing CSV adding a column using PowerShell in C# [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 9 years ago.

Improve this question

I have a fairly large CSV file (27MB) with at least 400,000 rows in it. I want to add a column to it, just like in this method and export it, except that I have to do it in C#. I have added the System.Management.Automation and the Microsoft.PowerShell namespaces. I would also like the new column to be the first column in the CSV. How might I be able to achieve this in the fastest way possible?

While the method used here could work, I specifically do not want to use any custom libraries not provided by windows.

This is what I've tried, but it doesn't seem to work:

PowerShell ps = PowerShell.Create();
ps.AddCommand("Import-Csv " + csvFileName + " |Select-Object *,@{Name='Name' ;Expression = {'setvalue'}} | Export-Csv " + csvFileName + " -NoTypeInformation");
ps.Invoke();

Possible duplicate of Parsing CSV files in C#

Nate Barbettini
– Nate Barbettini

2015-12-07 17:50:28 +00:00
Commented Dec 7, 2015 at 17:50 — Nate Barbettini
– Nate Barbettini, Commented Dec 7, 2015 at 17:50

Alfred Waligo · Accepted Answer · 2015-12-07 10:19:50Z

3

I solved the problem by changing the ps.AddCommand to ps.AddScript and surrounding the csvFileName with single quotes. The modified code is as follows

PowerShell ps = PowerShell.Create();
ps.AddScript("Import-Csv '" + csvFileName + "' |Select-Object *,@{Name='Name' ;Expression = {'setvalue'}} | Export-Csv '" + newCsvFileName + "' -NoTypeInformation");
ps.Invoke();

answered Dec 7, 2015 at 10:19

Alfred Waligo

2,9293 gold badges21 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

Importing CSV adding a column using PowerShell in C# [closed]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related