public static string[] SanitizeSplit(string s, string seperator)
        {
            List<string> result = new List<string>();
            bool mustSplit = true;

            string currentWord = string.Empty;

            for (int i = 0; i < s.Length; i++)
            {
                string l = s.Substring(i, 1);

                if ((l == "'" || l == "\"") && mustSplit)
                {
                    mustSplit = false;
                    continue;
                }

                if ((l == "'" || l == "\"") && !mustSplit)
                {
                    mustSplit = true;
                    continue;
                }

                if (l != seperator || (l == seperator && !mustSplit))
                    currentWord += l;
                else
                {
                    result.Add(currentWord.Trim());
                    currentWord = string.Empty;
                }
            }
            result.Add(currentWord);
            return result.ToArray();
        }

it ignores commas in a csv that are in string quotes

Method to import MySQL Scripts to MS SQL

mysql

C#