using System;

using System.Text;

using System.Text.RegularExpressions;   

using System.Collections.Generic;

​

public class Program

{

    public static void Main()

    {

        string test = "\"Erita \"\"Cuna,ku\"\"\",\"0,99\",\"05/10/2024 23:00:28\",\"06/10/2024 00:00:00\",DATA,\"UP_DOWN\"";

        //var result = ParseRow2(test, ',');

        var result = ParseCsvRow(test, ',');

        //var result = ParseCsvRow2(test, ',');

        foreach(var item in result){

        Console.WriteLine(item);

        }

    }

    public static List<string> ParseCsvRow2(string row, char separator)

{

    List<string> values = new List<string>();

    bool insideQuotes = false;

    StringBuilder currentValue = new StringBuilder();

​

    // Loop through each character in the row

    for (int i = 0; i < row.Length; i++)

    {

        char currentChar = row[i];

​

        // Check if we encounter a quote

        if (currentChar == '\"')

        {

            // Toggle insideQuotes flag, but handle consecutive quotes (escaped quotes within a value)

            if (insideQuotes && i + 1 < row.Length && row[i + 1] == '\"')

            {

                // It's an escaped quote, so we add a single quote and skip the next character

                currentValue.Append('\"');

                i++; // Skip the next quote character

            }

            else

            {

                insideQuotes = !insideQuotes;

            }

        }

        // If the current character is the separator and we are not inside quotes, it's the end of the value

        else if (currentChar == separator && !insideQuotes)

        {

            // Add the current value to the list and reset the StringBuilder

            values.Add(currentValue.ToString().Trim());

            currentValue.Clear();

        }

        else

        {

            // Add the current character to the current value

            currentValue.Append(currentChar);

        }

    }

​

    // Add the last value to the list

    if (currentValue.Length > 0)

    {

        values.Add(currentValue.ToString().Trim());

    }

​

    return values;

}

    public static List<string> ParseCsvRow(string row, char separator)

{

    // Initialize a list to store parsed values

    List<string> values = new List<string>();

    bool insideQuotes = false;

    string currentValue = "";

​

    // Loop through each character in the row

    for (int i = 0; i < row.Length; i++)

    {

        char currentChar = row[i];

​

        // Check if we encounter a quote

        if (currentChar == '\"')

        {

            // Toggle insideQuotes flag, but handle consecutive quotes (escaped quotes within a value)

            if (insideQuotes && i + 1 < row.Length && row[i + 1] == '\"')

            {

                // It's an escaped quote, so we add a single quote and skip the next character

                currentValue += "\"";

                i++; // Skip the next quote character

            }

            else

            {

                insideQuotes = !insideQuotes;

            }

        }

        // If the current character is the separator and we are not inside quotes, it's the end of the value

        else if (currentChar == separator && !insideQuotes)

        {

            // Add the current value to the list and reset the StringBuilder

            values.Add(currentValue.ToString());

            currentValue = "";

        }

        else

        {

            // Add the current character to the current value

            currentValue += currentChar;

        }

    }

​

    // Add the last value to the list

    values.Add(currentValue.ToString());

​

    return values;

}

    private static string[] ParseRow2(string row, char separator)

    {

        Console.WriteLine(row);

        string pattern = "(?:" + separator + "|^)(?:\"\"([^\"\"]*)\"\"|([^\"\""+separator+"]*)|(?="+separator+"))";

​

        var regEx = new Regex(pattern, RegexOptions.IgnoreCase | RegexOptions.Multiline);

        var matches = regEx.Matches(row);

​

        var result = new List<string>();

            Console.WriteLine("Match match in matches");

        foreach (Match match in matches)

        {

            Console.WriteLine("Gr0 => " + match.Groups[0].Value);

            Console.WriteLine("Gr1 => " + match.Groups[1].Value);

            Console.WriteLine("Gr2 => " + match.Groups[2].Value);

            Console.WriteLine("=======================");

​

​

            if (match.Groups[1].Success)

                result.Add(match.Groups[1].Value);

            else

                result.Add(match.Groups[2].Value.Trim());

        }

        Console.WriteLine("END: Match match in matches");

​

    return result.ToArray();

}

    private static string[] ParseRow(string row, char separator)

{

    row = row.Trim('"').Replace("\"\"", "\"");

        Console.WriteLine(row);

    string pattern = "(?:" + separator + "|^)(?:\"\"([^\"\"]*)\"\"|([^\"\""+separator+"]*)|(?="+separator+"))";

​

    var regEx = new Regex(pattern, RegexOptions.IgnoreCase | RegexOptions.Multiline);

    var matches = regEx.Matches(row);

​

    var result = new List<string>();

        Console.WriteLine("Match match in matches");

    foreach (Match match in matches)

    {

        Console.WriteLine("Gr0 => " + match.Groups[0].Value);

        Console.WriteLine("Gr1 => " + match.Groups[1].Value);

        Console.WriteLine("Gr2 => " + match.Groups[2].Value);

        Console.WriteLine("=======================");

​

        if (match.Groups[1].Success)

            result.Add(match.Groups[1].Value);

        else

            result.Add(match.Groups[2].Value.Trim());

    }

        Console.WriteLine("END: Match match in matches");

​

    return result.ToArray();

}

}