Posted By

Krummelz on 03/15/11

Tagged

mysql

Versions (?)

Last Edited at 03/15/11 07:58pm

Statistics

Viewed 618 times

Favorited by 0 user(s)

Related snippets

Method to import MySQL Scripts to MS SQL

/ Published in: C#

it ignores commas in a csv that are in string quotes

Highlighted TextExpand

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();
        }

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.