using System;

​

public class Program

{

    public static void Main()

    {

        // This can occur in a csv file where a column value also contains a comma      

        HandleQuotes("\"Smith, John\""); // Most occurences

        HandleQuotes("\"Smith\""); // One name only

        HandleQuotes("\"Smith,\""); // One name only with comma

        HandleQuotes("\" \""); // Space only

        HandleQuotes("\"\""); // Empty string

        HandleQuotes("\",\""); // Comma, no strings

        HandleQuotes("\"Smith, John \"the stronger\" \""); // Odd ball   John "the stronger" Smith

    }

​

    private static void HandleQuotes(string columnValue)

    {

        if (columnValue.StartsWith("\"") && columnValue.EndsWith("\""))

        {                   

            string valueNoQuotes = columnValue.Trim('"');  // Trim double-quotes from beginning and end of string.

            string fullName = valueNoQuotes.Trim();

            Console.WriteLine($"Full Name:{fullName}");

            string[] stringArray = fullName.Split(',');

            string lastName = stringArray[0].Trim();

            Console.WriteLine($"Last Name:{lastName}");

            if (stringArray.Length > 1)

            {

                string firstName = stringArray[1].Trim();

                Console.WriteLine($"First Name:{firstName}");

            }

​

            Console.WriteLine("-----------------------------------");

        }

    }

}