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

main.cs
using System.IO;
using System.Windows.Forms;

string csvFilePath = "";

// Select the CSV file using OpenFileDialog class
using (OpenFileDialog openFileDialog = new OpenFileDialog())
{
    openFileDialog.Filter = "CSV files (*.csv)|*.csv|All files (*.*)|*.*";
    openFileDialog.RestoreDirectory = true;

    if (openFileDialog.ShowDialog() == DialogResult.OK)
    {
        csvFilePath = openFileDialog.FileName;
    }
}

// Read the CSV file line by line, add a new column and write to a new file
string destinationFolderPath = "<your_destination_folder_path>";
string newCsvFilePath = Path.Combine(destinationFolderPath, Path.GetFileNameWithoutExtension(csvFilePath) + "_updated.csv");

using (var reader = new StreamReader(csvFilePath))
{
    using (var writer = new StreamWriter(newCsvFilePath))
    {
        while (!reader.EndOfStream)
        {
            var line = reader.ReadLine();
            var values = line.Split(',');

            // Add new column 'Situation' with Yes/No value
            bool situation = /* your logic to determine Yes/No */;
            string newLine = string.Format("{0},{1}", line, situation ? "Yes" : "No");

            writer.WriteLine(newLine);
        }
    }
}
1210 chars
39 lines