Feature Request: Allow imported csv files to have comment in them

[nh60211as]

Hi,
this is a simple feature request to let imported csv files have comment mechanism
such as ignoring lines start with #.

It can be done by modifying Cirilla/ViewModels/ImportCsvWindowViewModel.cs

Cirilla/src/Cirilla/ViewModels/ImportCsvWindowViewModel.cs

Lines 70 to 78 in 4817c0a

	using (FileStream fs = new FileStream(ofd.FileName, FileMode.Open, FileAccess.Read, FileShare.ReadWrite))
	using (TextReader tr = new StreamReader(fs, ExEncoding.UTF8))
	using (CsvReader csv = new CsvReader(tr, CultureInfo.InvariantCulture))
	{
	csv.Configuration.HasHeaderRecord = false;
	csv.Configuration.Delimiter = ";";
	values = csv.GetRecords<StringKeyValuePair>().ToList();
	}

to

using (FileStream fs = new FileStream(ofd.FileName, FileMode.Open, FileAccess.Read, FileShare.ReadWrite))
using (TextReader tr = new StreamReader(fs, ExEncoding.UTF8))
using (CsvReader csv = new CsvReader(tr))
{
	csv.Configuration.HasHeaderRecord = false;
	csv.Configuration.Delimiter = ";";
	// accept comment in csv files
	csv.Configuration.AllowComments = true;
	csv.Configuration.Comment = '#';

	values = csv.GetRecords<StringKeyValuePair>().ToList();
}

However, I found out that there doesn't seem to be a standard for csv commenting style.
So you might need to consider documenting or tell the user allowed commenting style if you were to add such feature,

Have a nice day and keep up the good work.

[Fusion86]

Looks good to me. I am currently working on a newer version, but I'll also update the current/older version on NexusMods with this change.

[nh60211as]

Thanks, look forward to it.