select csv file and for each line add a new column with yes or no and move the new csv to destination in csharp

To achieve this, you can use the following steps:

First, you need to add the System.IO namespace for performing input/output operations on files:


main.cs
using System.IO;
17 chars
2 lines

Next, you need to use the OpenFileDialog class to allow the user to select the CSV file:


main.cs
using (OpenFileDialog openFileDialog = new OpenFileDialog())
{
    openFileDialog.InitialDirectory = "C:\\";
    openFileDialog.Filter = "CSV files (*.csv)|*.csv|All files (*.*)|*.*";
    openFileDialog.FilterIndex = 1;
    openFileDialog.RestoreDirectory = true;

    if (openFileDialog.ShowDialog() == DialogResult.OK)
    {
        string filePath = openFileDialog.FileName;
        
        // Perform operations on selected file
    }
}
442 chars
15 lines

Inside the if block, you can read the contents of the CSV file using the StreamReader class and loop through each line:


main.cs
using (StreamReader reader = new StreamReader(filePath))
{
    using (StreamWriter writer = new StreamWriter(File.Create("destination.csv")))
    {
        string line;
        while ((line = reader.ReadLine()) != null)
        {
            // Perform operations on each line
            string newLine = $"{line},yes"; // Add "yes" to the end of each line
            writer.WriteLine(newLine); // Write the modified line to a new file
        }
    }
}
456 chars
14 lines

Finally, you can create a new file in the desired destination folder using the StreamWriter class and write the modified data to it.

Note: It's important to use the using statement when working with files in C# to ensure that the resources are disposed of properly when the operation is complete.

similar csharp code snippets

append to a csv file in csharp

find the last accessed date of a csv file in csharp

select csv file in csharp

find the name of a csv file in csharp

read a csv file in csharp

given a csv file with column "first_name" and "last_name", add a new column called full_name in csharp

select csv file and add a new column with yes or no and create new csv and move to destination in csharp

se csv file and add a column in csharp

find the size of a csv file in csharp

write to a csv file in csharp

related categories