CsvUtility 1.4.3

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

using CsvUtility;

namespace CsvUtilityTest
{
	/**
	Paste below and save as .csv or prepare some appropriate csv files
	
	seq,id,name,gender,birthday,remark
	0,10001,Foo,male,1970/10/1,
	1,10002,Bar,male,1980/2/1,test
	2,10003,John,male,1990/3/15,
	3,10004,Sophia,female,2000/12/5,

	Or,
	"seq","id","name","gender","birthday","remark"
	"0","10001","Foo","male","1970/10/1",""
	"1","10002","Bar","male","1980/2/1","test"
	"2","10003","John","male","1990/3/15",""
	"3","10004","Sophia","female","2000/12/5",
	
	Also can use \t insted of comma
	*/

	public partial class CsvUtilityTest : Form
	{
		public CsvUtilityTest()
		{
			CsvFileV2 _csv = null;

			ListBox listBox = new ListBox() { Parent = this, Dock = DockStyle.Top, };
			Button buttonOutput = new Button() { Parent = this, Dock = DockStyle.Top, Text = "Write as a csv", };
			buttonOutput.Click += (sender, e) =>
			{
				if (_csv != null)
				{
					SaveFileDialog sfd = new SaveFileDialog()
					{
						InitialDirectory = Application.StartupPath,
						FileName = string.Format("{0:yyyyMMdd_HHmmss}", DateTime.Now),
						DefaultExt = ".csv",
					};

					if (sfd.ShowDialog() == DialogResult.OK)
					{
						using (System.IO.StreamWriter sw = new System.IO.StreamWriter(sfd.FileName))
						{
							foreach (var l in _csv.AllLinesAsArray)
							{
								sw.WriteLine(CsvHelper.ToCsvFormat(l));
							}
							sw.Close();
						}
					}
				}
				else
				{
					MessageBox.Show("Open or parse first.");
				}

			};
			Button buttonShowEachLine = new Button() { Parent = this, Dock = DockStyle.Top, Text = "Show each line", };
			buttonShowEachLine.Click += (sender, e) =>
			{
				if (_csv != null)
				{
					foreach (var l in _csv.AllLinesAsArray)
					{
						List<string> list = new List<string>() { "Show next line?" };
						for (int i = 0; i < l.Length; i++)
						{
							list.Add(string.Format("{0}={1}", _csv.OriginalHeader[i], l[i]));
						}
						var ret = MessageBox.Show(string.Join(Environment.NewLine, list), "Line", MessageBoxButtons.YesNo);
						if (ret == DialogResult.No) break;
					}
				}
				else
				{
					MessageBox.Show("Open or parse first.");
				}

			};

			Button buttonView = new Button() { Parent = this, Dock = DockStyle.Top, Text = "View", };
			buttonView.Click += (sender, e) =>
			{
				if (_csv != null)
				{
					_csv.ShowDialog();
				}
				else
				{
					MessageBox.Show("Open or parse first.");
				}
			};

			Button buttonParse = new Button() { Parent = this, Dock = DockStyle.Top, Text = "Parse a text as a csv file", };
			buttonParse.Click += (sender, e) =>
			  {
				  var ofd = new OpenFileDialog() { InitialDirectory = Application.StartupPath, };
				  if (ofd.ShowDialog() == DialogResult.OK)
				  {
					  try
					  {
						  using (System.IO.StreamReader sr = new System.IO.StreamReader(ofd.FileName, Encoding.UTF8))
						  {
							  _csv = CsvFileV2.Parse(sr.ReadToEnd());

							  listBox.Items.Clear();
							  listBox.Items.Add(string.Format("Parse {0}", ofd.FileName));
							  listBox.Items.Add("[Unique header]");
							  listBox.Items.AddRange(_csv.UniqueHeader);
						  }
					  }
					  catch (Exception ex)
					  {
						  MessageBox.Show(ex.Message);
					  }
				  }

			  };

			Button buttonOpen = new Button() { Parent = this, Dock = DockStyle.Top, Text = "Open an csv file", };
			buttonOpen.Click += (sender, e) =>
			{
				var ofd = new OpenFileDialog() { InitialDirectory = Application.StartupPath, };
				if (ofd.ShowDialog() == DialogResult.OK)
				{
					_csv = CsvFileV2.Open(ofd.FileName);
					listBox.Items.Clear();
					listBox.Items.Add(string.Format("Open {0}", ofd.FileName));
					listBox.Items.Add(string.Format("Delimiter={0}", _csv.Delimiter));
					listBox.Items.Add(string.Format("Encoding={0}", _csv.Encoding));
					listBox.Items.Add(string.Format("Line count={0}", _csv.LineCount));
					listBox.Items.Add("[header]");

					for (int i = 0; i < _csv.OriginalHeader.Length; i++)
					{
						listBox.Items.Add(string.Format(" originall={0}, unique={1}", _csv.OriginalHeader[i], _csv.UniqueHeader[i]));
					}
				}
			};

			SizeChanged += (sender, e) =>
			{
				listBox.Height = ClientSize.Height - buttonOpen.Height - buttonView.Height - buttonShowEachLine.Height;
			};

			StartPosition = FormStartPosition.CenterScreen;
			Size = new Size(800, 600);
		}
	}
}