.NET Fiddle

CSharp · Console

/Program.cs

using System;
using System.Text.RegularExpressions;
					
public class Program
{
	public static void Main()
	{
	String[] columns = Regex.Split("\"0\",\"Column\",\"column2\",\"Column3\"", @"[^\s""']+|""([^""]*)""|'([^']*)");

		Console.WriteLine(columns.Length);
		Console.WriteLine(string.Join(",", columns));
	}
}
;